I have read this article, but it speaks about commands and property to use; i need to know which is the best choice between Select all my records in the Load event of my form (and wait) or to select a portion of the table (and i don't know how; i think i need to use PageSize, CacheSize Properties) and select again each time i need new data.

What do you think about this problem. All the example i have found show "Select * From....".

Thanks
>>I need to query a table on a remote SQL table with 150.000 records. I want to use ADO; i need to know how to work in this situation; after i have made my connection when i create my recordset i have to do "Select * From......" (but i have to wait too much time) or there is an other way ? Can someone help me ?
>>
>
>The article ADO Jumpstart for Microsoft Visual FoxPro Developers by John Petersen should help you http://search.microsoft.com/gomsuri.asp?n=3&c=rp_Results&siteid=us&target=http://msdn.microsoft.com/library/en-us/dnfoxgen/html/adojump.asp.