FileMaker developer, Adult fan of LEGO, nature conservationist - not necessarily in this order
This post is about dealing with outliers in the data when optimizing a scripted loop in FileMaker. It turns out that keeping outliers out of a loop is either simple or complicated. In complicated cases, much relies on the possibilities of storing ( and indexing ) the conditions that define different groups of outliers. … More Keeping outliers out of the loop?
At least five of FileMaker’s script steps appear to trigger what I am calling ‘speed bumps’: temporary drops in performance after their execution. This post shows when and how speed bumps can stack up and escalate ( even causing mega speed bumps ), and provides suggestions for how to avoid them. … More Understanding escalating ‘speed bumps’ and how to avoid them
FileMaker’s Insert from URL script step, and at least four more script steps, appear to trigger temporary drops in performance after their execution. This post will address how how big the total delay is and how long these ‘speed bumps’ last. … More ‘Speed bumps’, size and duration
Previously, I stumbled upon a ‘speed bump’ effect of the Pause script step in FileMaker scripts. That is, after a pause step, subsequent steps became slower. This post identifies five more steps with a similar effect. … More The Pause step and other speed bumps
This post introduces the Speed Test Viewer, a free FileMaker solution to explore speed measurement data. It also makes a demo file available which shows off the viewer’s features based on the data from my posts of the past two months … More Speed Test Viewer
How to design a mechanism to allow the user to gracefully abort script execution? ‘Allow User Abort’ needs to be off to prevent an ungraceful abort. Buttons do not work during script execution. Which other means are then left? The answer is only a keystroke away … More Gracefully aborting script execution
Rubber Boots Data 