>Hi Folks -
>I have an application which pretty much performs the same operation within a Do While !eof . Performing, Seeks, Scatters, Inserts, etc . When processing smaller file sets you do not see any performance degregation. However when we start processing larger file sets, performance almost at the same point each time, one can see the degregation . I do believe this has something to do with the app. not freeing up memory. Is there anyway to free up memory when going to the top of the Do while loop ?
SYS(1104) (available in VFP6 and 7 but only documented in 7) may help. From the VFP7 docs:
************
Purges memory cached by programs and data.
SYS(1104)
Returns
Numeric. 0, if successful
Remarks
You can improve performance by calling SYS(1104) after executing commands that make extensive use of memory buffers. This function is also useful when manipulating large tables.
*************
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up