Run 19 server scripts (PSoS) simultaneously to simulate other users using the FileMaker database at the same time.Use a FileMaker database with 2 million fake person data records in one table.Run the following test 12 times per server:.Latency from my computer to the server: 18 ms.10 GB gp2 (SSD) volumes for the FileMaker databases.Install and configure FileMaker Server 18.0.4.428 (Startup restoration OFF) and 19.1.2.234 (Sharing Lock ON) on 2 separate AWS t3.medium instances with the following specifications:.Check for performance differences between FileMaker Server 18.0.4 and FileMaker Server 19.1.2 when executing multiple expensive find operations.Simulate an environment with multiple users running find operations at the same time.None of our cloud servers use this feature, so I omitted it from the comparison. Moreover, I did not use the startup restoration feature introduced in version 18 due to its negative impact on the server’s reliability and stability. Because I didn’t find significant performance differences between FileMaker Server version 18.0.4 and 19.0.1, I skipped version 19.0.1 in my comparison. The goal of my tests was to see if there is a noticeable performance improvement in version 19.1.2. Wim Decorte created a tool known as Punisher, which can be used to analyze the impacts of different environments on FileMaker Server. This post focuses on testing parallel indexed finds. You can read more about these changes in the Claris articles Performance, stability, and reliability improvements in Claris FileMaker Server 19.1.2and in the FileMaker Server 19.1.2 release notes. Previously, only one indexed find operation could be performed at a time. So how fast is FileMaker Server 19.1.2?īecause a sharing lock is used to allow concurrent read access, version 19.1.2 can now perform find operations on indexed fields in parallel. My favorite addition is “parallel indexed finds,” which means that users can now run multiple find operations on a field simultaneously, unlike previous versions. Find operations on FileMaker Server 19.1.2 are up to 10x faster than beforeĬlaris released a new version of FileMaker Server with features that improve the performance and stability of your hosted FileMaker apps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |