>David,
>
>That is amazing! By moving the fields to the left I shaved off 20 seconds in response time.
>
>Now I'm going to check all my SQL Select statements, Thanks all!
>
>Adam
I believe that in the example suggested by David, and in your's, if it it similar, you will get even better performance if you use the between() statement. I suggest you try it. If it does, indeed, work faster, I will explain why.
Make sure you do NOT have an index on deleted(). Or at least, test with, and without, one.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)