>All views are paramaterized, thanks.
OK, that should help. Now, if you want to fetch thousands of records, you may still get slow performance.
In this case, one option is to reduce the network traffic, by analyzing where you are fetching too much data.
Also, you can try to improve your network. For instance, with 10 machines, a full-duplex switch, at 100 Mbps, might give you up to 200 times the performance of a 10 Mbps hub (assuming that all machines try to access the network at the same time).
If you really need to fetch a lot of data, you might be better off with a C/S solution. In this case, with stored procedures, the server does the processing, and merely returns a small result.
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)
