I have a program need to connect to MSSQL server 2000 and working for posting some data.
I use sqlpassthough to retriver data from the server and calculator some value and then use updateable cursor to post those data back to the server .
due to the posting process need take huge number of looping for the whold process.
I find that for the first hour of the client side the program only use up not more then 10% of CPU process ( but the sql server using 97 % of CPU process)

after 2 hour more the client side suddenly up to 99% of CPU process.
( at this moment I have check the sql server but nothing is running )
I have change may client machine still can't fully finish the whole process.

is any limitation for vfp to running a loop ?
or
am I need to do something to clear the tunnel (connection) between the client and server ?
or
am I need to do something to clear the memory of the client system in the program ?