ISQL Select Database slow 
Author Message
 ISQL Select Database slow

        Hi,

        I'm running Online 5.1, HP 9000/755, HP-UX 9.01, 512 MB RAM.  
        Two machines with identical installations of Online, same database
        schemas, different data.

        On one of the machines, when I run ISQL, Database menu, "Select",
        ISQL sits there for a looong time or until I press ^C in
        frustration.  Then I get the list of databases.  None of these
        are remote databases.  The longer the engine has been up, the
        longer this seems to take.  The only difference between the
        two machines that I can think of is that the one in question
        has more data and more activity.

        Trivial, you may say, but it's a training issue for some users
        (technicians).  I also hate not having any idea what's causing
        something with my database (real reason for question).

        Why?

        --Joana

--
Joan Armstrong
CIM Engineering, Hewlett Packard, Vancouver Division

HPDesk:      Joan Armstrong /HP5400/AL



Tue, 11 Jun 1996 02:09:28 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. select from table in different database is slow

2. Advice with SLOW SELECTs against large SQL Server database

3. Advice with SLOW SELECTs against large SQL Server database

4. New database is slower on large select queries.

5. select distinct painfully slow on my postgreSQl database

6. Select * slower than Select champ1, champ2, ???

7. Select * slower than Select champ1, champ2, --Need other opinion--

8. Slow ISQL on an HP laptop

9. isql really slow compared to query analyzer

10. fast in ISQL slow in ODBC

11. ISQL seems to be slower than Query Analyzer


 
Powered by phpBB® Forum Software