General information
Title:
Problem of SQL passthrough
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 ?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only