tulcanla,

I played around with it a bit and found a HUGE difference when adding a where to the query.

Normal selects and counts made no differance.

Did you use a condition in your select? If so, why is it so much faster for me?

Cheers,

Crispin