Read an interesting post by Chad Novotny at the Support Group this morning (read it here), which pointed out something I have never considered, but I suppose had frequently noticed.
It’s changed the way I think about Looping through Records and is a simple, quick and easy way to improve performance whilst using the Loop Script Step in FileMaker.
So as well as remembering to always click the “Exit after Last” option whilst performing the Go To Next Record/Request/Page:
You should also remember to insert a Freeze Window step into the script so that the visual element is turned off as your database loops through a couple of thousand or tens of thousands of records.
A simple easy tip that’ll no doubt save you plenty of time!
Oh and if you’re thinking of other performance gains you can get he also recommends:
1. Performing Loops on a Form View
2. Consider using a dedicated Layout if you’re using Script Triggers.
I’m a small business consultant enabling small business owners to achieve sustainable growth, whilst working part-time at Tees Valley Arts. For more about me personally see peterneal.co.uk