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.