HOnza’s Bits @ 24U – about FileMaker, AppleScript, iPhone, iPad, and more…

Marvelous Optimization #4 – Optimized Again

January 26, 2012

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 optimization during my session at Pause On Error [x] London 2011. Now you can watch the video of this part of my session below:

Tagged as: Advanced, Conference, Custom Functions, Development, Example, FileMaker, Optimization, Pause On Error

{ 0 comments }

Marvelous Optimization #3 – Faster Imports

December 11, 2011

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

Marvelous Optimization #2

November 10, 2011

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

Marvelous Optimization #1

November 7, 2011

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. You can find the original article here: FileMaker Script Execution Time Cut From 5 [...]

Debugging Scripts by Writing to Event.log

October 17, 2011

This is a fresh story of me spending hours trying to fix a technical issue and accidentally revealing a gold nugget. A few days ago one of my nightly server-side scripts stopped working without any apparent reason. But when I tried to run the script in FileMaker Pro it worked just fine. I really needed [...]

Random Set of Records (optimized)

September 29, 2011

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. I tried [...]

Custom Function Optimized to Evaluate Hundreds Times Faster

September 14, 2011

Two weeks ago I wrote an article about a FileMaker custom function I needed to preprocess some data imported from the web. I used this custom function in an auto-enter calculation to immediately preprocess the data while being imported. I created a server-side script that does the import every morning. But when I discovered that [...]

FileMaker Custom Function for HTML Entities

August 29, 2011

Just today I needed to decode HTML encoded text in FileMaker. I thought this must have been done many times before, so I tried to search for a suitable custom function at BrianDunning.com and FMFunctions.com. After checking few functions I found one that seemed pretty good.

5 reasons for not attending FileMaker DevCon

July 18, 2011

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:

Mac OS X 10.7 Lion – Upgrade or Wait?

July 13, 2011

Everyone is excited about Lion. Even though many new features on Mac OS X 10.7 are giving us improvements we kept asking for since 10.1, Apple has again succeeded in giving all the new features the strong essence of innovation that makes us unable to hesitate to install and try Lion out as soon as [...]

← Previous Entries

What do the capital O, FileMaker, AppleScript, iPhone, and iPad have in common...