Need to filter out items of list

[J. Landman Gay]

On 6/3/2014, 2:02 PM, Magicgate Software - Skip Kimpel wrote:
> Given that I have about
> 150,000 rows of data to process I am going to need to create some type of
> progress bar or counter.

Try it first without one, you might be surprised. The "repeat for each" 
construct is very fast.

One time I added a progress bar out of habit because I had so many lines 
to process. It took about 15 seconds to go through the whole loop. When 
I removed the progress bar, the loop completed in two or three seconds. 
It turned out that updating the progress bar took more time than the 
entire rest of the loop.

So see if the progress bar is really worth the overhead. If it's just a 
little slow, consider setting the cursor to a watch instead so the user 
knows something is happening. That has no overhead. Or if you do need a 
progress bar, only update it every 10th or 50th iteration or so.

-- 
Jacqueline Landman Gay         |     jacque at hyperactivesw.com
HyperActive Software           |     http://www.hyperactivesw.com