News, tips, advice, ideas, experience…

Google Maps become affordable

Google Maps become affordable - Preview Image

Since the introduction of WebViewer, Google Maps were quite popular in FileMaker solutions. What many FileMaker developers may have missed though is that in most cases they were using Google Maps API illegally and Google could ban their API key or IP address from accessing the feature at any time.

Echoes of the Past

Echoes of the Past - Preview Image

As time passes by, we quickly and easily get used to new technologies and new versions of all the apps we use. Occasionally, the history decently knocks on the door, checking if we remember. Just like recently, when a customer contacted us, asking for help with converting his invoicing solution, made in FileMaker Pro 1.0, to the current version.

Compression vs Encryption

Compression vs Encryption - Preview Image

Many years ago, when designing backup strategy for our server, we decided to take advantage of one typical aspect of FileMaker databases. By using a simple bash script, we could easily keep a history of 4 times more backups than without compression...

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.

Debugging Scripts by Writing to Event.log

Debugging Scripts by Writing to Event.log - Preview Image

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.

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.

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.

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.

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.