>Ernest,
>
>What's the megahertz of the processor involved, and the RAM size? Do you hear the HD doing anything during all those seconds (maybe it's going to SWAP)?
>
>I'd say 17 seconds sound long unless the machine involved is, say, a PIII 233 with 128meg (or thereabouts).
>
>
>>>Ernest, one other thing to try, is to redo the WITH:
>>>
>>>
>>>local loList, loItem
>>>loList = ThisForm.lvCritResult.listitems
>>>with loList
>>> loItem = .Add(, , id_acct)
>>>endwith
>>>
>>
>>
>>David,
>>You may find this quite funny. I decided that I will clean up the code as Jos Pols suggested correctly with - "put your WITH...ENDWITH statement outside of your SCAN...ENDSCAN loop" for speed improvement. I ran the applications and now the form releases but there is a delay in the release, depending on the number of records that were populated. With 1000 records, a couple of seconds and with 16000 records, about 17 seconds (unacceptable). With your suggestions above the results were the same. What's this delay?
Ernest