>I have a client/server application running on VFP5.0 with Microsoft SQL server as the backend. I experience a wierd phenomenon in that there is intermittent changes in speed in which the application runs. My application would be running fine until suddenly it would slow down drastically. There have been cases where the speed picks up after some time but in some cases the speed does not pick up at all.
>
> I do not think the software is the problem because I have a few clients which run perfectly well with the expected speed and so on. Hardware may not also be the problem bcoz we have tried many options like using a new PC to changing the network cables. What I believe may be the problem is the ODBC connection that is made to the SQL server. Has anyone experienced such a problem? Please advise. Thanks.

What is your application doing??