Advanced

Marvelous #4

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

Read more →
Marvelous #1

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

Read more →
Event.log

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

Read more →
Custom Function Optimized

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

Read more →
Thumbnail image for PHP Debugging & FileMaker Custom Functions Do Exist

PHP Debugging & FileMaker Custom Functions Do Exist

May 25, 2011

I have just read Anders Monsen’s post A Simple Debug Function for PHP at the Mightydata’s blog. My first thought was this is similar to what I have been doing since I learned PHP a few years ago. But then I discovered something very bad about myself…

Read more →

FileMaker Script Execution Time Cut From 5 Hours To 6 Seconds

March 17, 2011

Sometimes, not often, I accidentally achieve results that look too marvelous to be real. But they are. Just like in this case. Last week I assigned Petr, our internal system developer, the task to optimize one server-side script. The script recently started taking over 8 hours to run and reaching the expiration limit we have [...]

Read more →