Now the whole thing runs a lot faster. (about 2 seconds for a 85000 rows result compared to about 11 seconds for the same result using the old query)
I just wonder why those queries aren't slow with Linux-2.4.25. Using 2.4.25, the old queries ran as fast as the new ones on 2.6.5...
I forgot to add: The new queries still take about double the time the older queries used to take with Linux-2.4.25.
-dirk
--
D i r k F "o r s t e r l i n g
r@zorbla.de http://r.zorbla.de/
-------------
Always remember that you are unique. Just like everyone else.---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
