>On SQL Server 6.5 with VFP 5.0:
>
>Client/Server program when executed it takes quite long
>to get the screen appear. But on another make of PC, it
>is much faster.
>
>It seems that everytime when accessing to the SQL Server
>databases, it is quite slow. Pls advise, thanks.
Actually, there are lots of reason which can affect data retrival using ODBC.
e.g.
1. Remote Views are not sharing connection.
2. Indexes are not defined for the fields used in WHERE clause.
3. How many records are you getting in one shot? etc.
Please describe your problem with an example.
- Jayesh