Slow Script in FM

[Styx]

One for the newbies:

I was developing the concept of auto-parsing Requirements and found that the script I wrote ran really s-l-o-w-l-y. At the time I never had time to investigate why, I lived with it. I assumed that with over 100k of requirement records, this was the reason.

However, recently with some spare time on my hand, after a bit of investigation I discovered that the script step ‘new record request’ was running with a very complicated layout displayed. It took around 2 seconds to generate a new record.

Now with the script step running with a simple layout it flies.

And yes, I was a bit red-faced when I realized my mistake.

[Sam]

Sigma has a bunch of blank layouts for most of the main tables specifcally for this purpose. The less you give Filemaker to render the faster it runs. Though Ive found this much less of an issue these days (post FM11).