Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Bad performance |
Author |
Message |
|
Posted : 2008-03-10 17:23:49 |
Hello,
the query execution is extremely slow. I'm running this query:
SELECT * FROM customer where isactive = 1
Even though the table has 3 lines only, it takes the system 25 seconds to return them. I tried using NOSYNC, UNPTIMIZED, etc., and also disabled the optimization, but got no good results. Just to test the connection from VS 2005 or 2008 it takes like 15 seconds.
What would be wrong?
Thanks!
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-03-11 12:51:44 |
I just ran:
SELECT {fn curtime()} FROM customer where isactive = 1
and the difference in the timestamp for 116 rows was 2 seconds. Isactive isn't indexed, so if you have heaps of inactive customers it's going to scan all of them in the whole table and take time. |
|
|
|
|