We are sorry, information on this page is available only in Czech. Use Translator Switch to Czech

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...  

Call us Call

+420 608 301 880

Usually available on working days between 7am and 5pm GMT

We'll call you back if you call from a discoverable phone number and fail to reach us

Let us call you Let us
call you

By completing and sending the form you agree that 24U s.r.o., a company established under the laws of the Czech Republic, with its registered office: Zvole u Prahy, Skochovická 88, CZ-25245, registered in the Commercial Register with the Municipal Court in Prague, section C, inset 74920 will use your personal data contained in the form for the purpose of sending 24U’s news, updates and other commercial communications. Providing 24U with personal data for the said purpose is optional. Details on personal data processing and on your rights connected therewith are contained in 24U’s Privacy Policy.

Loader Image