>John,
>A result set of 4 records out of 20,000 should be instantaneous if the query is fully optimized. Does your query contain several joins? I've noted that performance may drop dramatically when you join many tables. Could you show us your query?
I can confirm this. One 9-table query took me 50 seconds over the network. After separating this into several queries (joining the previous result with one additional table each time), I got the time down to 2 seconds. This is reasonable for my application, 'cause I retrieved much more records.
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)