Speeding FileMaker Performance with Truncate Table

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”

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

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 – Part II”

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

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 – Part I”