Hi James,

There are several techniques to handling this. You might wish to consider creating stored procedures on the server that send back a limited result set based on a parameter and use SQL passthrough (SQLEXEC) to call that sp. Or, look at the FetchSize remote view property to limit the number of rows.


>My company is starting to use SQL server and i am going to be hitting it with Foxpro 6 when i designed my views i noticed it didnt really let you do anything in your code untill it had gone to the bottom of the file retrieving all the records i am curious is there a way to speed this up so that when i hit it with a sql statement the speed is quite nice all my indexes are set up fine on the server so i know thats not an issue but i will be working with close to 11 million rows and speed is of the essence any recomendations would be greatly appreciated
>Thanks
>James