# \#performance **URL:** https://the.fmsoup.org/tag/performance/61.md [Latest](https://the.fmsoup.org/latest.md) · [Categories](https://the.fmsoup.org/categories.md) · [Tags](https://the.fmsoup.org/tags.md) --- ## [General-Purpose Read Method, Take Three](https://the.fmsoup.org/t/general-purpose-read-method-take-three/5722)
**Author:** [@karimhanafi](https://the.fmsoup.org/u/karimhanafi)\ **Replies:** 21\ **Last updated:** [September 28, 2026, 1:15pm UTC](https://the.fmsoup.org/t/general-purpose-read-method-take-three/5722 "2026-09-28T13:15:17Z")
I have tried building a general-purpose read method twice before — one common method that other methods call instead of hand-rolling their own Finds/SQL, returning data in a predictable structure. I ended up retiring bot… --- ## [Little tidbits from the FileMaker conference](https://the.fmsoup.org/t/little-tidbits-from-the-filemaker-conference/4355)
**Author:** [@MonkeybreadSoftware](https://the.fmsoup.org/u/MonkeybreadSoftware)\ **Replies:** 5\ **Last updated:** [October 12, 2024, 12:19pm UTC](https://the.fmsoup.org/t/little-tidbits-from-the-filemaker-conference/4355 "2024-10-12T12:19:53Z")
Back from the conference in Liechtenstein, I wrote down a few of the tidbits we learnt. Missing serial numbers If you use serial numbers for new records in FileMaker, you may notice that sometimes the serial numbers hav… --- ## [Performance update from 24u and server side script queues](https://the.fmsoup.org/t/performance-update-from-24u-and-server-side-script-queues/4339)
**Author:** [@Kirk](https://the.fmsoup.org/u/Kirk)\ **Replies:** 0\ **Last updated:** [October 2, 2024, 5:06pm UTC](https://the.fmsoup.org/t/performance-update-from-24u-and-server-side-script-queues/4339 "2024-10-02T17:06:25Z")
24u is a great resource for lots of FM things and Honza is truly focused on performance. This new blog post on their site has some good info. For those not aware of the “server side script queue” mentioned in the post… --- ## [Optimising Container Fields for best Performance in the Cloud](https://the.fmsoup.org/t/optimising-container-fields-for-best-performance-in-the-cloud/2377)
**Author:** [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Replies:** 5\ **Last updated:** [July 1, 2024, 10:04pm UTC](https://the.fmsoup.org/t/optimising-container-fields-for-best-performance-in-the-cloud/2377 "2024-07-01T22:04:27Z")
I've just been asked to improve the performance of a file that been moved from the desktop into the cloud. The problems occur on a list view that displays images. This is an art/artist database. All of the images are st… --- ## [Skinny tables and Summary fields](https://the.fmsoup.org/t/skinny-tables-and-summary-fields/4116)
**Author:** [@Dutchman](https://the.fmsoup.org/u/Dutchman)\ **Replies:** 3\ **Last updated:** [May 9, 2024, 11:28pm UTC](https://the.fmsoup.org/t/skinny-tables-and-summary-fields/4116 "2024-05-09T23:28:15Z")
Hiya - I'm working on a solution that uses a fair number of summary fields. As a result, the total field count for the primary data table is higher than I'm used to (currently 35 fields). Normally I keep my field count … --- ## [Self Relationship](https://the.fmsoup.org/t/self-relationship/4114)
**Author:** [@pfro](https://the.fmsoup.org/u/pfro)\ **Replies:** 5\ **Last updated:** [May 9, 2024, 9:17pm UTC](https://the.fmsoup.org/t/self-relationship/4114 "2024-05-09T21:17:26Z")
Hi all, I run a manufacturing outfit and we do everything with filemaker since 15 years. We produce cosmetics. We have a product table which has a manyToMany self-join via a "components" table. Because products are m… --- ## [FMS19.6.3 poor performance on M1 mini / Ventura](https://the.fmsoup.org/t/fms19-6-3-poor-performance-on-m1-mini-ventura/3372)
**Author:** [@xochi](https://the.fmsoup.org/u/xochi)\ **Replies:** 45\ **Last updated:** [January 18, 2024, 7:09pm UTC](https://the.fmsoup.org/t/fms19-6-3-poor-performance-on-m1-mini-ventura/3372 "2024-01-18T19:09:53Z")
I'm in the process of upgrading several servers from 2012 Mac Minis (Intel Core i5 or i7) to M1 (or M2) Mac Minis. The old servers were running macOS 10.13 and FileMaker Server 18.x, new ones are running latest ventura… --- ## [Unresponsive replace operation - extremely slow performance](https://the.fmsoup.org/t/unresponsive-replace-operation-extremely-slow-performance/3903)
**Author:** [@traut](https://the.fmsoup.org/u/traut)\ **Replies:** 8\ **Last updated:** [January 12, 2024, 5:18am UTC](https://the.fmsoup.org/t/unresponsive-replace-operation-extremely-slow-performance/3903 "2024-01-12T05:18:37Z")
Hi all, I heared some advice recently that a scripted loop is faster than a replace operation. From my experience up to FMP11, replace had always been significantly faster. But today I tried FMP20 and was shocked by th… --- ## [🤯 constrain on an unindexed calc](https://the.fmsoup.org/t/constrain-on-an-unindexed-calc/3843)
**Author:** [@rivet](https://the.fmsoup.org/u/rivet)\ **Replies:** 2\ **Last updated:** [December 6, 2023, 6:57pm UTC](https://the.fmsoup.org/t/constrain-on-an-unindexed-calc/3843 "2023-12-06T18:57:23Z")
For a subset of a million records requiring further constraint, it's quicker to constrain on an unindexed calc field. Confining on an indexed field would involve processing the million-record index. (cued up 35:45) … --- ## [Reviving old Macs, good or bad idea](https://the.fmsoup.org/t/reviving-old-macs-good-or-bad-idea/3501)
**Author:** [@planteg](https://the.fmsoup.org/u/planteg)\ **Replies:** 10\ **Last updated:** [April 15, 2023, 3:18pm UTC](https://the.fmsoup.org/t/reviving-old-macs-good-or-bad-idea/3501 "2023-04-15T15:18:10Z")
Hello to all of you, my question is regarding to Mac computers, and I am wondering it is worth updating them. Mac no 1, Mac mini Late 2014 As you can see, it's not a Ferrari. Currently I run on it FMS 19.6.3.302 and… --- ## [Benchmark FMS 18 vs 19 using 24U BenchTest](https://the.fmsoup.org/t/benchmark-fms-18-vs-19-using-24u-benchtest/3387)
**Author:** [@xochi](https://the.fmsoup.org/u/xochi)\ **Replies:** 0\ **Last updated:** [February 15, 2023, 3:53pm UTC](https://the.fmsoup.org/t/benchmark-fms-18-vs-19-using-24u-benchtest/3387 "2023-02-15T15:53:36Z")
I have discovered what appears to be a 5x-10x slowdown in FMS19 compared to FMS18. The symptoms are: very slow calcuation update when one table is updating stored calculated fields fields using data from related table… --- ## [M2 Mac Mini Options](https://the.fmsoup.org/t/m2-mac-mini-options/3359)
**Author:** [@xochi](https://the.fmsoup.org/u/xochi)\ **Replies:** 9\ **Last updated:** [February 14, 2023, 6:17pm UTC](https://the.fmsoup.org/t/m2-mac-mini-options/3359 "2023-02-14T18:17:31Z")
I'm considering a M2 mac mini for a FileMaker server. This is to replace the current workhorse which is a 2012 Core i7 Mac Mini with 16GB RAM. Our database is about 10GB so does fit in a 16GB machine, but it's growing … --- ## [Local vs. external tables for stand-alone app](https://the.fmsoup.org/t/local-vs-external-tables-for-stand-alone-app/3266)
**Author:** [@mzarin](https://the.fmsoup.org/u/mzarin)\ **Replies:** 3\ **Last updated:** [December 15, 2022, 6:09pm UTC](https://the.fmsoup.org/t/local-vs-external-tables-for-stand-alone-app/3266 "2022-12-15T18:09:37Z")
Has anyone done benchmarking to see what benefit there is when building a stand-alone app to using tables local to the file vs. external when the external tables are part of a much larger system? I've got a "mothership"… --- ## [Most efficient way to navigate to the new layout](https://the.fmsoup.org/t/most-efficient-way-to-navigate-to-the-new-layout/2506)
**Author:** [@nihm](https://the.fmsoup.org/u/nihm)\ **Replies:** 20\ **Last updated:** [October 24, 2022, 3:30pm UTC](https://the.fmsoup.org/t/most-efficient-way-to-navigate-to-the-new-layout/2506 "2022-10-24T15:30:15Z")
I'd like to create a script that will make a new related record by navigating to a new layout, creating a record, then returning to the original layout. I'd like to use this method, and not the magic key method. What i… --- ## [FMServer slowdown](https://the.fmsoup.org/t/fmserver-slowdown/2020)
**Author:** [@Code-J](https://the.fmsoup.org/u/Code-J)\ **Replies:** 9\ **Last updated:** [February 26, 2022, 3:30pm UTC](https://the.fmsoup.org/t/fmserver-slowdown/2020 "2022-02-26T15:30:11Z")
Hi all, N.B. I'm posting this in the Community too. Looking for some advice on an issue one of my customers has had lately. They are experiencing significant slowdowns and server not responding warnings at random times… --- ## [Too many Global Variables?](https://the.fmsoup.org/t/too-many-global-variables/2827)
**Author:** [@bowdendata](https://the.fmsoup.org/u/bowdendata)\ **Replies:** 6\ **Last updated:** [April 4, 2022, 5:54pm UTC](https://the.fmsoup.org/t/too-many-global-variables/2827 "2022-04-04T17:54:54Z")
Hi All, I just started working on an existing solution that uses what I consider to be a large number of global variables - approximately 75+ of them. They are mostly all defined during the startup process. They contain… --- ## [Performance benchmarking FM18 Intel to FM19 on M1](https://the.fmsoup.org/t/performance-benchmarking-fm18-intel-to-fm19-on-m1/2810)
**Author:** [@xochi](https://the.fmsoup.org/u/xochi)\ **Replies:** 33\ **Last updated:** [March 31, 2022, 8:11pm UTC](https://the.fmsoup.org/t/performance-benchmarking-fm18-intel-to-fm19-on-m1/2810 "2022-03-31T20:11:56Z")
I have some FileMaker processes which can take 3-4 hours to run. Can I speed them up? My current setup: FM18 Server on a a 2012 Mac Mini with Core i7 Is it worth upgrading to: FM19 Server on M1 mac mini According… --- ## [Using FMPerception to Assess Spider Graph](https://the.fmsoup.org/t/using-fmperception-to-assess-spider-graph/2688)
**Author:** [@steverichter](https://the.fmsoup.org/u/steverichter)\ **Replies:** 6\ **Last updated:** [January 9, 2022, 11:09pm UTC](https://the.fmsoup.org/t/using-fmperception-to-assess-spider-graph/2688 "2022-01-09T23:09:16Z")
Question: Having never used FMPerception before, would this tool be useful in diagnosing specific graph issues that could be affecting performance/speed? Environment: FMS19, FMP19, Win 10. Background: My Point-of-Sale … --- ## [FileMaker Performance Variations - platforms, networking and Apple Silicon Macs](https://the.fmsoup.org/t/filemaker-performance-variations-platforms-networking-and-apple-silicon-macs/2638)
**Author:** [@AndyHibbs](https://the.fmsoup.org/u/AndyHibbs)\ **Replies:** 5\ **Last updated:** [December 13, 2021, 8:06pm UTC](https://the.fmsoup.org/t/filemaker-performance-variations-platforms-networking-and-apple-silicon-macs/2638 "2021-12-13T20:06:21Z")
This has stemmed from our new SaleFaith manufacturing/MRP system due to go live in the first week of January. As part of this we’re migrating the data from an ECI M1 ERP system. The process initially involves some manual… --- ## [Record Commits and Computer Sleeps](https://the.fmsoup.org/t/record-commits-and-computer-sleeps/2322)
**Author:** [@bdbd](https://the.fmsoup.org/u/bdbd)\ **Replies:** 12\ **Last updated:** [July 18, 2021, 10:45pm UTC](https://the.fmsoup.org/t/record-commits-and-computer-sleeps/2322 "2021-07-18T22:45:38Z")
Does anyone know if FileMaker Pro automatically flushes its cache when a computer goes to sleep? --- ## [Inter-Application-Communication in FM18/19](https://the.fmsoup.org/t/inter-application-communication-in-fm18-19/2157)
**Author:** [@Markus](https://the.fmsoup.org/u/Markus)\ **Replies:** 4\ **Last updated:** [May 25, 2021, 4:38pm UTC](https://the.fmsoup.org/t/inter-application-communication-in-fm18-19/2157 "2021-05-25T16:38:49Z")
Is anybody running into issues like this? Single-File system and Multi-File systems db-app created under FM16 or earlier, now under FM18 and/or FM19, Mac and Windows db-app was running perfect under earlier versions of… --- ## [About the Performance channel](https://the.fmsoup.org/t/about-the-performance-channel/1856)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 1\ **Last updated:** [May 12, 2021, 10:23am UTC](https://the.fmsoup.org/t/about-the-performance-channel/1856 "2021-05-12T10:23:10Z")
We are building a thematic collection of FileMaker expertise focused on performance and usability. Our first project is on the performance of vanilla FileMaker including a limited range of relevant plugins. We are cons… --- ## [Fastest Key Value Pairs](https://the.fmsoup.org/t/fastest-key-value-pairs/2048)
**Author:** [@FileKraft](https://the.fmsoup.org/u/FileKraft)\ **Replies:** 15\ **Last updated:** [April 22, 2021, 1:30pm UTC](https://the.fmsoup.org/t/fastest-key-value-pairs/2048 "2021-04-22T13:30:39Z")
In need of speed improvements for a layout with a heavily loaded portal where conditional formatting is applied using ~6 predicates for each field and displaying 12 fields in one row and a couple of hide conditions also … --- ## [Performance core principles: 10. Scripting](https://the.fmsoup.org/t/performance-core-principles-10-scripting/1867)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 24\ **Last updated:** [March 31, 2021, 9:39pm UTC](https://the.fmsoup.org/t/performance-core-principles-10-scripting/1867 "2021-03-31T21:39:46Z")
SCRIPTING How do I write fast and easy to maintain scripts to automate my solution? In part 2 of this section we will examine server side scripting called by Perform Script on Server or called by a FileMaker Server Sc… --- ## [Development Scheduling Optimized with Web Viewer](https://the.fmsoup.org/t/development-scheduling-optimized-with-web-viewer/1972)
**Author:** [@HOnza](https://the.fmsoup.org/u/HOnza)\ **Replies:** 0\ **Last updated:** [March 27, 2021, 12:24pm UTC](https://the.fmsoup.org/t/development-scheduling-optimized-with-web-viewer/1972 "2021-03-27T12:24:19Z")
We use our own app called Collector to manage our software development projects. A few years ago my colleague Milan started feeling the need to schedule our development capacity more precisely. So we created a detailed p… --- ## [Nested sets: another data model for record hierarchies](https://the.fmsoup.org/t/nested-sets-another-data-model-for-record-hierarchies/1897)
**Author:** [@Bobino](https://the.fmsoup.org/u/Bobino)\ **Replies:** 2\ **Last updated:** [March 14, 2021, 10:05pm UTC](https://the.fmsoup.org/t/nested-sets-another-data-model-for-record-hierarchies/1897 "2021-03-14T22:05:46Z")
Continuing the discussion from Performance core principles: 13. Miscellaneous: I guess that was because you were relying on some data that could not be indexed. It is one of the drawbacks of the adjecency list model (t… --- ## [Performance core principles: Introduction to the project](https://the.fmsoup.org/t/performance-core-principles-introduction-to-the-project/1869)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 10\ **Last updated:** [March 10, 2021, 4:42pm UTC](https://the.fmsoup.org/t/performance-core-principles-introduction-to-the-project/1869 "2021-03-10T16:42:45Z")
Performance is a concern of every FileMaker developer, it is the most complained about subject but also the less discussed. We plan to assemble the wisdom and experience of our community here in order to develop and publ… --- ## [Is there a reason not to verify backups](https://the.fmsoup.org/t/is-there-a-reason-not-to-verify-backups/1631)
**Author:** [@BenMiller](https://the.fmsoup.org/u/BenMiller)\ **Replies:** 12\ **Last updated:** [February 3, 2021, 8:57am UTC](https://the.fmsoup.org/t/is-there-a-reason-not-to-verify-backups/1631 "2021-02-03T08:57:54Z")
When setting up scheduled backups in FileMaker Server I always select the optional verify backups option. I guess a backup that is not verified will run faster, But I don't want to have unverified backups if something go… --- ## [At Claris Engage 2020 you could be at sessions and in the lobby at the same time](https://the.fmsoup.org/t/at-claris-engage-2020-you-could-be-at-sessions-and-in-the-lobby-at-the-same-time/1323)
**Author:** [@HOnza](https://the.fmsoup.org/u/HOnza)\ **Replies:** 0\ **Last updated:** [September 15, 2020, 4:49am UTC](https://the.fmsoup.org/t/at-claris-engage-2020-you-could-be-at-sessions-and-in-the-lobby-at-the-same-time/1323 "2020-09-15T04:49:31Z")
The first Claris Engage, a successor of FileMaker DevCons, was originally planned to take place in Nashville, Tennessee. The coronavirus pandemic has changed plans for most live events this year, and so Claris Engage tu… --- ## [Get (foundcount) calc field to count related records + bonus discussion about the ETS program](https://the.fmsoup.org/t/get-foundcount-calc-field-to-count-related-records-bonus-discussion-about-the-ets-program/1294)
**Author:** [@Bobino](https://the.fmsoup.org/u/Bobino)\ **Replies:** 20\ **Last updated:** [September 7, 2020, 7:23pm UTC](https://the.fmsoup.org/t/get-foundcount-calc-field-to-count-related-records-bonus-discussion-about-the-ets-program/1294 "2020-09-07T19:23:51Z")
Continuing the discussion from Counting related records for a large data set: @jormond I know this can give great performance, but at the same time, I have steered away from using this technique, considering it a bit o… [Next page](https://the.fmsoup.org/tag/performance/61.md?match_all_tags=true&page=1&tags%5B%5D=performance)