The things listed below are all good things to look at. But another thing you might want to check is the network protocol being used. Having IPX/SPX on the client, for example, drastically slows down SQL Server data access. I have found that clients work best using either TCP/IP alone, or TCP/IP & NetBeui.
>>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.
Eric Shaneson
Cutting Edge Consulting