Intermediate

Thumbnail image for Optimization Madness

Optimization Madness

November 14, 2013

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. The good news for you if you missed the event is that the whole session was recorded and [...]

Read more →
Speedy Snail

Why is FileMaker 12 slow?

May 31, 2012

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

Read more →
Marvelous #3

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

Read more →
Marvelous #2

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

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 →
Dice

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

Read more →
HTML Entities

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.

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 →

Infinite Hierarchy

March 29, 2011

Last week Hal Gumbert mentioned on Twitter that he was “working on a FileMaker quote to display and edit a BOM ( Build of Materials ) that can go 9 levels deep.” Probably the most efficient and user friendly way to implement this is using a tree view with collapsible/expandable items. This is nothing new [...]

Read more →

FileMaker PHP Error 7 (Running Out Of Memory) resolved

February 23, 2011

Yesterday I got so stuck with an issue that I wanted to send a question to a mailing list. But (un)fortunately I sent it from a wrong e-mail address so it did not reach the list. Then, before discovering that I used the wrong e-mail address I actually resolved the issue, so now I can [...]

Read more →