Bob,

How many records are returned from these queries. Rememver, the difference is probably not the time it takes for the query to run on the server, but the time it takes for it to return to the PC over the network.

As you know, using the internal bus of your server to return the query to the client will run faster than some 10mbps or even 100mpbs network.

What are the time differences for a 1 record query? I think the more records returned the larger the difference would be.

Also, 5 hours to upsize 50 megs is a long time. Is there any virus checking on the client? IF so I would turn that off and see if it makes a difference. Also, what protocall are you using form client to sql server? I think TCP/IP is the fastest, named pipes can be slow I have heard.

Also, is the SQL Server driver the same version on both machines?

Are the remote connection settings set the same on both versions of foxpro.

HTH,
BOb



>>> I wouldn't discount hardware issues. It could also be a bad network connection, such as a bad NIC or wire. These things can be detected by a good network engineer.<<
>
>Actually, I WOULD NEVER RULE OUT ANYTHING UNLESS I AM SURE. At the risk of sounding arrogant, I have been a network engineer for over 15 years (all of it spent in lan/wans). FWIW, I am a Cisco/MCSE/CNE/ASE. The certifications are paper, the battle wounds I have from the field are real. or other problems.
>
>Unfortunately, I am clueless when it comes to SQL Server. If I had to bet, I would say it is driver related. The only thing I can see is that the driver on my workstation is version 3.70.06.90 and the version on my server is 3.70.06.23. The only other thing I can see is maybe SQL server is just slow for client workstation queries and I am spoiled with VFP.
>
>Thanks for the help though.