Make sure you have indexes(clustered or otherwise) on your tables. This will speed up access.


>Hi All,
>
>I'm using SQL passthrough functions to get data from SQL server 2000, but the rate of data retrival is very slow; (on the server itself). Can you pl help me out how to get the data from the SQL Server quickly. I m using VFP 7; SQL Server 2000 and SQL Passthrough Functions
>
>Thanks