Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

Script "Compiler"

Idea created by fmpdude on Aug 19, 2017

Comment • 5

Active

Score5

It would be amazingly helpful if scripts were much faster.

Although my posted benchmark results may not be considered relevant for many FMP applications (and I would agree), I recently documented a case where a 20,000,000 FMP script loop, with no database access and only a couple transcendental functions, took an hour and 20 minutes to complete in FMP, but that same loop took only 1.5 seconds in Java.

Now, I'm not asking for or expecting Java-level performance from FMP, but it would be fantastic if there were some script optimization for much better (especially looping, apparently) performance.

5 Comments

Benjamin Fehr Aug 19, 2017 6:00 AM
I already know people building work arounds with JS though a function would be processed by the webkit instead of FM native. This always results in a tremendous performance boost.

Some relevant Feature Requests:
Perform JavaScript Function
Native interaction between Web viewer and FileMaker Scripts (Web viewer JS API)
Like • Show 0 Likes0
Actions
fmpdude @ Benjamin Fehr on Aug 19, 2017 6:08 AM
Very Cool!

Thanks.
Like • Show 0 Likes0
Actions
PeterDoern Aug 19, 2017 1:58 PM
see also Compile Script to Plugin
Like • Show 1 Like1
Actions
monkeybreadsoftware Feb 14, 2018 3:05 AM
Well, FileMaker is build to run scripts when there is nothing else to do.
So when FileMaker is idle, it checks if it has a current script and does a few lines till comes back to check if there are GUI events.

To speed up, you should request a mode where a script would run in background like on a server without GUI stuff.
Like PSoS, but locally and in background without GUI. Triggers should be delayed or disabled.
Like • Show 0 Likes0
Actions
fmpdude @ monkeybreadsoftware on Feb 14, 2018 3:18 AM
My workaround for the DOS batch-file performance of FMP scripts is to avoid them whenever possible.

Or, I just use a script for a few little lines of code with no looping. Anything beyond that I send out to a micro-service or, when performance is an issue with lots of database access (ALWAYS), I often end up not using FMP for that application. Plus, picking FMP for a given project is further limited by the fact FMP lacks any RegEx for queries, which I often need.

Again, for my documented test (with zero database access):
- FMP: 1 HOUR, 19 MINUTES.
- JAVA: 1.5 SECONDS
(JDBC with FileMaker data, from my test and posted data file, is 6X faster than FMP alone, also)
Like • Show 0 Likes0
Actions

Script "Compiler"

Related Content

Recommended Content