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
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
The techniques of this post are limiting the use of ExecuteSQL and how to reduce wait times for a user when all else fails. … More Accelerate by refactoring. Low hanging fruit 6.
In this post: one tip which applies to all programming, but has a maintenance trap, and one very straightforward performance tip regarding setting variables. … More Accelerate by refactoring. Low hanging fruit 5.
This post addresses two easy scripting and calculation improvements . 6 Insert instead of set a variable One way to collect data from high number of records ( or websites or other sources ) is to visit them one by one and store the collected data in one variable. Suppose that one wants to … More Accelerate by refactoring. Low hanging fruit 4.
This post will deal with a couple of ways to prevent FileMaker from unnecessarily generating a layout and performing the necessary calculations while running a script. 4 Freeze the window and use empty layouts for long running scripts Perhaps the most basic means that exist to prevent FileMaker from unnecessarily generate a layout and … More Accelerate by refactoring. Low hanging fruit 3.
Rubber Boots Data 