Sorry, I can't give you more help. The only suggestion I can give, is to use cursors instad of array wherever possible. I don't know if this is doable in this specific situation, though.
>>
Release yourarray
>>Release all like la*
>>
>
>Yes I have used release memvar, But AFAIK VFP puts it in deleted on the backburner NTI index which it uses internally and cleans up when Wait for input.
>
>Any way I created a fll to take care of the same from MSDN help docs
>
>>And UPDATE to VFP9!!!
>
>Sure. But will take time. there are a lot of things i need to upgrade.
>Only when i start selling my product.
>
>thanx
>suhashegde
>
>>
>>>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
