See if this
VFP slowdown after processing large amounts of data Thread #
1182599 may give you some ideas.
>hi,
>
>Sorry hit the enter button too early.
>
>I have a long running code.
>
>It has to process about 1056 items and does a select SQL into array number of records in array (600)
>
>Then the array is copied into 2 arrays and used with other variables.
>The Array is fed to a fll and the return values are updated to the table.
>
>While processing the code is fast intially say 50 sec/ 100 records But as an when the count reaches above 500 it slows drastically.
>
>I have put Flush for 100 records , But what i feel is that the variables are not released fast enough eventhough I have a Release Array command.
>
>How can I specifically release those arrays from Being put to Deleted in NTI (which i believe VFP uses internally) ??
>
>Thanx
>
>suhashegde
If it's not broken, fix it until it is.
My Blog