
How to Unfreeze a While Do?
I codes a while do to find matching records and pull values from a master table. When I hit OK, it froze.
I 'm sure I made a coding error -- in other languages I would have suspected an inadvertent "infinite do loop".
On the other hand, it just may be too big a search. The master file is very large 200,000 and the while do includes two data element updates from the Master. The view table is about 80 records.
How do I stop the freeze and recover?
-
I created my own "Advanced Search" functionality. What I found sped things up was to wrap your script in <do as server>...<end>. It moves the crunching to the cloud, not your browser.
In fact, what I do is I have a button that runs a search in that way and then fills a text field with the ids as a string. I then have a View which displays only the records it can find in that textfield. That has sped things up for me with 5k+ records, takes a second or so to display the matching records.