When the first FileMaker DevCon Developer Cup took place at FileMaker DevCon 2014 many people asked me why I was not participating. So I applied for the next one in 2015. I was selected out of the over 1500 attendees to be one of 12 actually competing, and I won both the separately evaluated design challenge and the whole contest as well.
In May, I participated in Pause[x]Berlin 2013, a European format of the popular unconference Pause On Error, organized for FileMaker developers by FileMaker developers.. There I presented a session called Optimization Madness focused on optimizing performance of FileMaker solutions.
Last September I wrote an article about a custom function that I optimized to evaluate hundreds times faster. At the end of the article, I challenged my readers and myself by claiming that the already optimized custom function can be optimized even further. Do you remember? Later on I actually really optimized it again, and talked about this.
This example demonstrates that even a single-step script can be optimized. You just have to think a little bit out of the box... I was showing this as a surprise in my session Marvelous Optimizations at Pause On Error [x] London 2011. I used a sample file with 25 fields and 5,000 records and imported these records 5 times in a row in just 13s.
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 is the first example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011. I already wrote about this optimization some time ago. It’s the one that led me to unveil the Marvelous Optimization Formula. I took the example and added FM Bench Detective into it to be able to exactly measure and examine what happens.
To attend or not to attend? That's the question I am asking myself every year since 2002 when I attended my first FileMaker DevCon. I have attended 8 DevCons so far, and skipped one. I have identified the following 5 possible reasons for not attending: