News, tips, advice, ideas, experience…

Arachnophobia at FileMaker Konferenz 2017

Arachnophobia at FileMaker Konferenz 2017

In October 2017 we proudly sponsored the German-speaking FileMaker Konferenz again. HOnza Koudelka, our mad optimizer, presented two sessions there, both focused on FileMaker performance. Now we’re bringing back the best of those sessions for your benefit, so don’t hesitate and dive into the deep waters of FileMaker performance with us.

24U team
Customer from Utah at our booth
Customer from Washington at our booth
 
 
24U team
Customer from Utah at our booth
Customer from Utah at our booth
 

Our first session was focused on results of almost forty thousand (as opposed to four thousand from the previous year) performance tests our team had performed and evaluated to compare different versions of FileMaker Pro and FileMaker Server, different techniques to do the same thing, and different conditions, such as data patterns, indexing, or system platform. HOnza also added some specific tests based on the suggestions from the attendees of the previous year's FileMaker Konferenz, some of which had quite interesting results.

By experience from a customer, we learned that storing a Base64 representation of container data can be detrimental to the solution’s performance. We also learned and revealed how FileMaker Server notifies each client about changes in a database made by other clients and how one user’s actions can have impact on the solution’s performance for everyone else.

HOnza's second session was focused on our recent great discovery of the impact of database structure on its performance. HOnza explained why database structure affects the speed of opening a file and starting a new database connection session, and showed the results of our team's conversion of our own system from the "spider" structure to “anchor/buoy".

This conversion was an exciting 2-month project, resulting in file opening to become more than twice as fast and some procedures even faster. This proves that being arachnophobic, and so avoiding spiders, is a good thing for a FileMaker developer.

As part of his tests and this presentation HOnza also revealed that even the new popular technique known as selector-connector can have similar negative impact on performance as the "spider" structure.

We are glad that over 50 people out of 180 attendees came to one or the other of his sessions and even participated in very technical discussions. HOnza's first session even became the second best evaluated session of the first day of the conference. We’ll appreciate if you let us know how the above excerpts of the best parts of our sessions helped you in your own development.

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.