Tag: PSOS

FileMaker Perform Script on Server: Episode IX – Endless PSoS Abilities

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 2024, FileMaker Server, Techniques

If you go looking for a FileMaker script step called Perform Script on Server on Server, you are not going to find it. Because this isn’t a new script step, but rather the same Perform Script on Server (PSoS) that we have always had, except that now it is FileMaker Server-compatible.

This capability allows FileMaker to fire off other Perform Script on Server scripts (from an existing script that is running on server), and either wait for those to complete or not. I have been thinking that with this feature one could build a main controller script and a set of worker scripts. That is just one idea, of many, I am sure.

Continue reading “FileMaker Perform Script on Server: Episode IX – Endless PSoS Abilities” →

FileMaker 2023 Perform Script on Server with Callback – Episode IV: Call Ya Later

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 2023, FileMaker Server, Performance, Techniques

FileMaker 2023 introduces Perform Script on Server with Callback, a new asynchronous method to execute scripts with FileMaker Server. Now we have a way for FileMaker Server to execute another script, a “Callback” script, when one script is done processing via Perform Script on Server. It’s like calling your virtual assistant and instead of waiting on the phone for 5 minutes for info, they basically call you back when they are ready with an answer.

The end result is improved performance, better management of complex script workflow, enhanced user experience, and new possibilities for handling integration with APIs, email and services like Claris Connect.

Continue reading “FileMaker 2023 Perform Script on Server with Callback – Episode IV: Call Ya Later” →

Finer Faster FileMaker Precision: Measuring How Long It Takes

by Vincenzo Menanno
Posted in All, Claris Development, FileMaker, FileMaker 19, FileMaker 2023, FileMaker Server, Logging, Monitoring, Performance, Techniques, Testing

I often like to measure performance, because I am curious if some small change can lead to subtle, or maybe not so subtle, improvements. For the longest time my Swiss Army knife for measuring Claris® FileMaker® performance has been:

Get ( CurrentTimeUTCMilliseconds )

Continue reading “Finer Faster FileMaker Precision: Measuring How Long It Takes” →

Logging PSoS Activity: Episode III – Return of the JSON

by Vincenzo Menanno
Posted in All, FileMaker, FileMaker Server, JSON, Logging, Performance, Security

In looking back at our initial approach to logging FileMaker PSoS (Perform Script on Server) activity, I reflect back on a number of times where this has been extremely helpful. If you have come to rely on the benefits of PSoS then you also know some of its challenges — one of the biggest is debugging and monitoring how long sessions take.

Since FileMaker 16 introduced JSON, in new systems we’ve switched over to using JSON as the main way of exchanging data for parameters. Because we also use PSoS in new systems, we updated our method for PSoS Logging and this blog entry talks about the changes we made there and also restates the usefulness of this log.
Continue reading “Logging PSoS Activity: Episode III – Return of the JSON” →

Speeding FileMaker Performance with Truncate Table

by Jud Wolfskill
Posted in All, FileMaker, FileMaker 15, FileMaker Server, Performance, Techniques, Testing

Managing Data You Use and Throw Out

We develop FileMaker applications because we want a place to store information for the long term. We track events, tasks, contacts, finances—FileMaker can track almost anything. To update information, the application might ingest a spreadsheet.

Continue reading “Speeding FileMaker Performance with Truncate Table” →

FileMaker Log Files: Episode VII – PSoS Awakens

by Vincenzo Menanno
Posted in All, FileMaker, FileMaker Server, Performance, Techniques

Now more than ever we’re relying on Perform Script on Server (PSoS) to maximize FileMaker performance, so naturally a need arose for a way to proactively monitor how many concurrent scripts are being triggered. This type of logging helps us see if we’re reaching our maximum limit, or have a rogue script eating up processing power.

Continue reading “FileMaker Log Files: Episode VII – PSoS Awakens” →

What Are Your Imports Waiting For? FileMaker Perform Script on Server – Episode II

by Vincenzo Menanno
Posted in All, FileMaker, FileMaker Server, Performance, Techniques

Introduction

I hope that since our previous blog post you have been exploring the possibilities created by FileMaker’s Perform Script on Server (PSoS). This article is a continuation of the PSoS discussion and includes more cool things you can do with it, specifically running database imports on FileMaker Server.

Continue reading “What Are Your Imports Waiting For? FileMaker Perform Script on Server – Episode II” →

100x Faster – Flight Testing FileMaker Perform Script on Server – Episode I

by Vincenzo Menanno
Posted in All, FileMaker, FileMaker Server, Performance, Techniques

Read the follow up to this blog post at What Are Your Imports Waiting For? FileMaker Perform Script on Server – Part II

Introduction

Since the release of FileMaker 13 we have been exploring a new feature called “Perform Script on Server” (PSoS) and trust me there are many cool things you can do with it. I’m going to describe how PSoS works, how it’s best implemented, and how our tests show PSoS can drastically improve database performance, more than 100x in some situations. However, there are also a number of considerations before you run wild and convert scripts to execute via PSoS. So, I’ll cover these as well.

Continue reading “100x Faster – Flight Testing FileMaker Perform Script on Server – Episode I” →