ENG
≡ Menu

24U Tips

Promise to yourself: No more compromises! Get the best performance out of FileMaker Pro by optimizing your solutions and achieve 100+% speed gains in almost no time.

Subscribe

Tags

TOP TIPS

How and why I won the FileMaker DevCon Developer Cup

When the first FileMaker DevCon Developer Cup took place at FileMaker DevCon 2014 many people asked me why I was not participating. So I applied for the next one in 2015. I was selected out of the over 1500 attendees to be one of 12 actually competing, and I won both the separately evaluated design challenge and the whole contest as well, to become a proud FileMaker DevCon 2015 Developer Cup Champion.

Now, 3 weeks before the next DevCon 2016, when people are thinking of participating in the new FileMaker Developer Challenge, I am going to reveal, why I decided to participate in the Developer Cup last year, what I did to win it, and what it has given me in the end. Learn more →

How and why I won the FileMaker DevCon Developer Cup thumbnail

Team Development

The good thing about growth is that you're getting stronger. You can deliver more work in less time and provide more unique values to your clients, such as stability, reliability, or variability. The difficult part is to make the team work together like clockwork.
Learn more →

Team Development thumbnail

Client Offload

In the last article I mentioned I attended Pause[x]Berlin 2013 with my team and gave you the video recording of my session Optimization Madness. I'm glad to tell you that I have one more recording from this event for you. We also recorded Fabrice Nordmann's session Client Offload. 

You can watch the whole Fabrice's session below:
Learn more →

Client Offload thumbnail

Optimization Madness

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 so now you can watch it below... Learn more →

Optimization Madness thumbnail

Tamagotchi – Ready for the Future

Several years ago, when Tamagotchi became popular, I thought it was a good way to teach a kid how to take care of a pet without an actual risk of hurting or killing one. Back at that time I had no idea that the meaning of this toy was much deeper...Learn more →

Tamagotchi – Ready for the Future thumbnail

Why is FileMaker 12 slow?

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 after upgrading to FileMaker 12. Check it out yourself in my LinkedIn poll. Learn more →

Why is FileMaker 12 slow? thumbnail

Marvelous Optimization #4 – Optimized Again

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: Learn more →

Marvelous Optimization #4 – Optimized Again thumbnail

Marvelous Optimization #3 – Faster Imports

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 13 seconds. OK, 13 seconds is not bad but what if you need to import data into FileMaker Go  over network? If you want to know how I imported the same data in less than 3 seconds, watch the following video from my Pause On Error session. Learn more →

Marvelous Optimization #3 – Faster Imports thumbnail

Marvelous Optimization #2

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 the example has FM Bench Detective script steps included to measure the original and the optimized script more precisely. Watch the video recorded at Pause On Error below to learn more details about this optimization. Learn more →

Marvelous Optimization #2 thumbnail

Marvelous Optimization #1

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 Hours To 6 Seconds.I simply took the example and added FM Bench Detective into it to be able to exactly measure and examine what happens in the slow and the optimized script. Now you can watch the result in this video recorded at Pause On Error. Learn more →

Marvelous Optimization #1 thumbnail

Debugging Scripts by Writing to Event.log

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 a way to debug the script on the server. Learn more →

Debugging Scripts by Writing to Event.log thumbnail

Random Set of Records (optimized)

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 to apply it to a set of 50,000 records of randomly generated data. Then I made it much faster... Learn more →

Random Set of Records (optimized) thumbnail

Custom Function Optimized to Evaluate Hundreds Times Faster

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 the import was taking over an hour every day, I saw it deserves some optimization. I used FM Bench Detective and optimized the custom function to evaluate up to several hundreds times faster... Learn more →

Custom Function Optimized to Evaluate Hundreds Times Faster thumbnail

FileMaker Custom Function for HTML Entities

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. Learn more →

FileMaker Custom Function for HTML Entities thumbnail

5 reasons for not attending FileMaker DevCon

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: Learn more →

5 reasons for not attending FileMaker DevCon thumbnail

Mac OS X 10.7 Lion – Upgrade or Wait?

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 we are able to.

But we are also afraid. What if some important apps stop working? Learn more →

Mac OS X 10.7 Lion – Upgrade or Wait? thumbnail

PHP Debugging & FileMaker Custom Functions Do Exist

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... Learn more →

PHP Debugging & FileMaker Custom Functions Do Exist thumbnail

Blog Moved

I have just finished switching my blog from Posterous to a self-hosted WordPress.org based site.

You may have noticed I mentioned this idea on Twitter some time ago. I had mainly three reasons for this change:
Learn more →

Infinite Hierarchy

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."
Learn more →

FileMaker Script Execution Time Cut From 5 Hours To 6 Seconds

Sometimes, not often, I accidentally achieve results that look too marvelous to be real. But they are. Just like in this case. Learn more →

Per-Database FileMaker Plug-Ins

Hal Gumbert (@campsoftware) has started an interesting topic on Twitter today:

"I would love to include FileMaker plugins IN the FileMaker file within the 'File Options' dialog. Should have 'File Plugins', 'App Plugins', and 'Computer Plugins'. 'File Plugins' would be stored IN db."

This topic quickly turned to be full of ideas and opinions. Way more than can reasonably fit in Twitter's message length limit. Learn more →

FileMaker PHP Error 7 (Running Out Of Memory) resolved

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. Learn more →

Designing Buttons in Pages [updated]

When developing a software (FileMaker solutions, iOS apps in my case) we often need nice looking user interface elements such as buttons. Learn more →

24U Net Remote Demo video

I have recently uploaded a new demo video of 24U Net Remote to the Net Remote's website. It's the best video I have ever created, so I wanted to show off ;-) Learn more →

First Lessons from Developing for FileMaker Go

In the old times before FileMaker Go, before tab control, before anchors, before multiple windows per file, in the age of 13-inch CRT monitors, the most frequent challenges I was facing when developing FileMaker solutions were:

  1. How to fit all the necessary information into such small space
  2. What the hack to put in that weird empty area on the layout

These days we have so many convenient ways to manage the real estate of FileMaker layouts that I often almost forget all the knowledg I gained at those old times.

Until last year... Learn more →

Indicate Progress in FileMaker Go and 11

When I was preparing a sample file for the How To Prevent Support Calls video I wanted to make it as cool as possible, so I decided to optimize it for FileMaker Go. I quickly discovered that I need a plug-in free alternative for the progress dialog. Learn more →

24U SimpleDialog Plug-In 4.0 Special Offer [updated Jul 24, 2010]

The crushing offer is over

OK, I had a crushing offer for you but it has already expired.

But the new SimpleDialog 4 is worth the money even without discount, isn't it?
Learn more →

Stay Independent

Do you use FileMaker plug-in? Why? Let's try something. Stop reading now, scroll down to the Comments section and answer these two questions. I am seriously curious about your answers. Then scroll back up and read the rest of this article. Learn more →

Prevent Support Calls [updated July 29, 2010]

After being silent for a while, busy preparing a new product launch, I am now back and cannot wait to tell you what you all probably guessed already. Pssst, rumors have that an all new SimpleDialog is rolling out. But before I confirm or deny the rumors, I have a story for you. Learn more →

Top 10 things I like about #FileMaker 10

Over a year has passed since the FileMaker 10 family of products was released. Do you still hesitate to upgrade? I am constantly meeting customers who have not yet upgraded to the latest version of FileMaker Pro and FileMaker Server, so I have decided to share my top ten reasons why "ten" is so great Learn more →

GetAsDate(x) GetAsDate( x & “”)

Ever had a trouble getting FileMaker Pro convert text to date reliably? Learn more →

Top 10 things I hate about #FileMaker Pro 10

This page intentionally left blank. Learn more →

The best 10minute workflow to demo #FileMaker at a press conference

I am preparing a 10minute demo for a press conference where I will be showing FileMaker to journalists who have never seen it and have no idea what it is about. Learn more →

I have got my #FileMaker branded flash drive

512 MB is not much but it is nice... Thanks #FileMaker TechNet ;-) Learn more →

Products Sales Other