ISO FileMaker Magazine

Prior to FileMaker 13 we never even had the option of performing scripted tasks where the data actually exists. The processing of a script, client side, always had, and still does, make a full round trip for all kinds of these processing activities. Many times, FileMaker does it's best to optimize whatever is being done, but it's still not as fast as executing certain things directly on the server.

With the addition of Perform Script on Server we gained a REALLY BIG performance boost by being able to perform most any script on the server.

While there are still various limitations, such as the number of simultaneous server side scripts, it's absolutely something that any serious FileMaker developer needs to know how to use.

One of the biggest issues with running server side scripts with Perform Script on Server is the fact that you need to know what's happening when the script is running, how to troubleshoot and most importantly, how to replicate the current user context. That is, the proper layout and the exact same found set to be used for processing the data. This video specifically covers how to restore the user context for processing a found set of data. If you're interested in making this process happen as quickly as possible, then using Perform Script on Server is what you should learn to use.

When FileMaker 13 was released, one of its sleeper features was Perform Script on Server. Yeah, developer’s recognized it, but didn’t really know how to value its power.

With the subsequent release of FileMaker 14, and FileMaker Go 14 in particular, the advantages of Perform Script on Server simply can’t be overlooked by anyone creating solutions within FileMaker Pro.

If your FileMaker solution has any number of users, beyond a very small number, then the performance gains can be quite significant for certain tasks.

While certain script steps like Export Field Contents cannot be used with Perform Script on Server, there is a wealth of functionality which can be harnessed through the use of server side plug-ins. Because of what you can do on the server side, there are few, if any limitations. Need to communicate with other web services via ODBC, SQL, REST, SOAP (pick your acronym)? Want to send bulk HTML email using an online service like Amazon’s SES mail sending? Need to automate a routine import which normally task just a bit too long?

Using PSoS is simply a matter of understanding what’s happening server side and knowing how to troubleshoot. Fortunately, this video will provide you with all the know-how!