The second example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011 was the script for selecting Random Set of Records. I found this example in the FileMaker Knowledge Base and optimized it to run at least 158 times faster when selecting 10 random records out of 50,000.

This version of the example has FM Bench Detective script steps included to measure the original and the optimized script more precisely. Watch the video recorded at Pause On Error below to learn more details about this optimization.

Click the button below to download updated version of the example:

Download zipped fp7 file (23.3 MB)

Note that you need to download 24U FM Bench Detective, install the included 24U Toolbox Plug-In (no registration necessary) and put the FMBench_Log.fp7 file into the same folder as the example for the precise measurements to work.

This optimization proved that it is important to always consider multiple solutions because the solution that's better in one situation may be worse in another.

The next one was a surprise I never shown before. I demonstrated how even a script with a single script step can be optimized. So stay tuned, I'm going to put it online soon...