Remember to Freeze the Window

FileMaker Pro

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:

Exit After Last
Always remember to click the Exit After Last Check Box!

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.

Filed under: FilemakerTagged with: , ,