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

News, tips, advice, ideas, experience…
Showing 37 Results for "optimization"
Show all articles

BenchTest Community Results 1st Wave

BenchTest Community Results 1st Wave - Preview Image

Since June, when I made an updated public beta of BenchTest available, 45 valid complete test results were submitted by 19 different people. It’s just a beginning, but enough to make some comparisons and share the results with you, so here they come, along with an updated version of the tool.

FileMaker Performance Lab June 2021

FileMaker Performance Lab June 2021 - Preview Image

During the January FileMaker Performance Lab meeting I shared the first beta version of BenchTest, my performance testing tools. I was working on it since then and today I am pleased to announce the first version ready for you to easily compare the performance of your own FileMaker Server or hosting with my reference setup.

New Year with New Test Results

New Year with New Test Results - Preview Image

A new year has come and we all hope it will push us forward to better tomorrows. New year also deserves new performance test results, especially since Claris released FileMaker 19.2 just a few days ahead of Christmas. So I used some of the calm holiday time to prepare new sets of tests and  discover some new interesting things…

FileMaker Server 19.1.2 Performance First Results

FileMaker Server 19.1.2 Performance First Results - Preview Image

Claris has released FileMaker Pro 19.1.3 and FileMaker Server 19.1.2. I have added these new versions to my performance lab and here are my first test results. Linux version seems slightly faster than Windows version, JavaScript is way faster than FileMaker calculation engine, and sorting on server can surprise you as much as it has surprised me.

Time Warp to FileMaker Konferenz 2016

Time Warp to FileMaker Konferenz 2016 - Preview Image

After presenting at four German-speaking FileMaker conferences, let us take a brief look back at the first one in 2016 where all our European DevCons presence began. For the first time, in 2016 we had some really interesting stuff to show, including two case studies and results of over four thousand performance tests.

Pause On Error Portland 2014 Recording

Pause On Error Portland 2014 Recording - Preview Image

After participating on Pause[x]London 2011 and Pause[x]Berlin 2013 I got invited to attend Pause On Error Portland 2014 as well. Even though my schedule did not allow me to attend in person, I managed to host one session about Efficient Optimizing and Troubleshooting of FileMaker Solutions and Business Processes remotely over Skype. 

How Fast is the New FileMaker Cloud?

How Fast is the New FileMaker Cloud? - Preview Image

How fast or slow is FileMaker Cloud and what should you know before deciding to throw away your old Mac mini you're using to run FileMaker Server and move your databases to FileMaker Cloud? Let me put the other aspects, such as cost or security, aside for now, and focus solely on the performance.

Perform Script On Server

Perform Script On Server - Preview Image

The idea of being able to off-load time consuming tasks from FileMaker Pro to FileMaker Server is as old as the scripting abilities of FileMaker Pro, which were introduced with the FileMaker Pro 3 release. But it was the FileMaker Server 13 that finally made this idea easy to implement.

Text or Numbers - What's Faster

Text or Numbers - What's Faster - Preview Image

One of the questions I am getting from time to time since I testing FileMaker performance is whether there is any significant difference between performance of text and number fields, So I tested it and discovered that there is even a case when indexed field can be slower than an undindexed one.

Safe Housekeeping

Safe Housekeeping - Preview Image

When you have a FileMaker solution that you have developed and used over a long time, you are likely to have objects like scripts, table occurrences, value lists, custom functions or layouts, that you don’t use any more. Once in a while you probably want to delete some of them to remove their impact on your solution’s size and performance.

Optimization Madness

Optimization Madness - Preview Image

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.

Why is FileMaker 12 slow?

Why is FileMaker 12 slow? - Preview Image

A lot has been written and said since FileMaker 12 was released about its speed, compared to FileMaker 11. Emotions left aside, if I was supposed to compile all the recent findings into a single brief message, I would say that some people find FileMaker 12 slower than FileMaker 11 while others experience improved performance.

Marvelous Optimization #4 - Optimized Again

Marvelous Optimization #4 - Optimized Again - Preview Image

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.

Marvelous Optimization #3 - Faster Imports

Marvelous Optimization #3 - Faster Imports - Preview Image

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.

Marvelous Optimization #2

Marvelous Optimization #2 - Preview Image

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.

Marvelous Optimization #1

Marvelous Optimization #1 - Preview Image

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.

Random Set of Records (optimized)

Random Set of Records (optimized) - Preview Image

I noticed that one of the articles updated in the official FileMaker Knowledge Base on September 23, 2011 was explaining how to select a random set of records in a FileMaker database. I was wondering how fast the currently recommended technique is and whether I can make it faster with the help of FM Bench.

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