>1. If you shut down the application and re-start, does it speed back up? What about the workstation if you reboot?

Works great if I shut the app and estart. I don't have to restart VFP.

>2. Have you run this from a second workstation? If so and the problem doesn't appear there, it could be the network card in the first workstation.

It''s consistent.

>3. Was that CPU utilization on the VFP machine or the SQL Server machine?
The client. SQL seems fine and CPU usage is less than 1%.
Most of the activity is on the client.

>>Has anyone had experience with a VFP-SQL 6.5 getting slower
>>as a process carries on? I have a process that was taking
>>24 hours and is now taking 40+. CPU usage has gone from 40-50%
>>to 85-100% yet memory remains at 80-100k.
>
>1. If you shut down the application and re-start, does it speed back up? What about the workstation if you reboot?
>
>2. Have you run this from a second workstation? If so and the problem doesn't appear there, it could be the network card in the first workstation.
>
>3. Was that CPU utilization on the VFP machine or the SQL Server machine?