Stanley,
Can you show us a code fragment of your calculation and update? How many rows are being retrieved and then updated?
>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 ?