Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCAN memory leak
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00139923
Message ID:
00141083
Views:
28
>>G'day again Bruce,
>>what about ...
>>
>>count for thisform.checkbits() != -1 to ncount
>>
>>(though I wouldn't expect it to be faster than a scan)
>
>The reason I had the scan was that sometimes I had to put an BROW or EXIT in it so I could stop to examine a record that was != -1...eventually I did try COUNT...but it was very slow, I don't think it's suited for this. Then I put the entire Checkbits method into a rather awkward but functional SQL, and pulled off all the records != -1. It's not only much faster, but I have all the bad records to view in a cursor, also...I never tested the COUNT to see if it resolved the memory leak, that would help to prove/disprove the SCAN leak...perhaps if I have a couple hours to spare sometime I'll check it out...

Hi Bruce
OK, if you ever do find some resolution or info about leaky scans post something on the UT; because sometimes I get into huge loops in statistical apps ( sometimes I work on cross correlation of results of 100,000 students with 10 exam results over 250 subjects :-)) - can take hours.... as you know.
Regards
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform