# NickLightbody's **URL:** https://the.fmsoup.org/c/curated-collections/nicklightbodys-collections/67.md [Latest](https://the.fmsoup.org/latest.md) · [Categories](https://the.fmsoup.org/categories.md) · [Tags](https://the.fmsoup.org/tags.md) --- ## [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… --- ## [Performance core principles: 1. Unstored calculations](https://the.fmsoup.org/t/performance-core-principles-1-unstored-calculations/1857)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 41\ **Last updated:** [April 22, 2021, 8:30am UTC](https://the.fmsoup.org/t/performance-core-principles-1-unstored-calculations/1857 "2021-04-22T08:30:59Z")
1. UNSTORED CALCULATIONS When are unstored Calcs useful and when should they be avoided? It depends! Unstored calculations can be useful and can be used as long as we are aware of what the limits of sensible applicati… --- ## [Performance core principles: 2. Indexing](https://the.fmsoup.org/t/performance-core-principles-2-indexing/1858)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 4\ **Last updated:** [April 16, 2023, 8:16am UTC](https://the.fmsoup.org/t/performance-core-principles-2-indexing/1858 "2023-04-16T08:16:43Z")
INDEXING What effect does indexing have on Performance? Why would you want to reduce it? How can you design to reduce indexing? --- ## [Performance core principles: 3. Relationships](https://the.fmsoup.org/t/performance-core-principles-3-relationships/1859)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 10\ **Last updated:** [January 19, 2022, 9:55pm UTC](https://the.fmsoup.org/t/performance-core-principles-3-relationships/1859 "2022-01-19T21:55:04Z")
RELATIONSHIPS What effect do relationships have on performance and what are the alternatives? What are examples of performant and non-performant relationship graph designs? --- ## [Performance core principles: 4. Table widths](https://the.fmsoup.org/t/performance-core-principles-4-table-widths/1860)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 35\ **Last updated:** [July 14, 2021, 3:51pm UTC](https://the.fmsoup.org/t/performance-core-principles-4-table-widths/1860 "2021-07-14T15:51:23Z")
TABLE WIDTHS What effect do wide tables (tables with many fields) have on performance? How can you reduce table widths? Where do repeating fields fit in? --- ## [Performance core principles: 5. Predicates](https://the.fmsoup.org/t/performance-core-principles-5-predicates/1862)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 3\ **Last updated:** [March 10, 2021, 2:10pm UTC](https://the.fmsoup.org/t/performance-core-principles-5-predicates/1862 "2021-03-10T14:10:19Z")
PREDICATES What are the performance implications of how you create relationship predicates, how many you use and their order? --- ## [Performance core principles: 6. Startup](https://the.fmsoup.org/t/performance-core-principles-6-startup/1863)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 1\ **Last updated:** [March 10, 2021, 4:41pm UTC](https://the.fmsoup.org/t/performance-core-principles-6-startup/1863 "2021-03-10T16:41:37Z")
STARTUP How can you improve the user experience by designing a fast startup into your solution? --- ## [Performance core principles: 7. Screen redrawing](https://the.fmsoup.org/t/performance-core-principles-7-screen-redrawing/1864)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 2\ **Last updated:** [March 10, 2021, 9:36pm UTC](https://the.fmsoup.org/t/performance-core-principles-7-screen-redrawing/1864 "2021-03-10T21:36:39Z")
SCREEN REDRAWING What is the effect on performance of windows, lists and portals redrawing and what is the effect of using freeze? When is it useful to use a blank layout within a scripted process and how does it effec… --- ## [Performance core principles: 8. ExecuteSQL](https://the.fmsoup.org/t/performance-core-principles-8-executesql/1865)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 10\ **Last updated:** [April 11, 2021, 3:01am UTC](https://the.fmsoup.org/t/performance-core-principles-8-executesql/1865 "2021-04-11T03:01:24Z")
EXECUTESQL What are the performance implications of using ExecuteSQ? When should you use this and how should you use it properly? --- ## [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… --- ## [Performance core principles: 11. Transactions](https://the.fmsoup.org/t/performance-core-principles-11-transactions/1868)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 1\ **Last updated:** [March 10, 2021, 5:49pm UTC](https://the.fmsoup.org/t/performance-core-principles-11-transactions/1868 "2021-03-10T17:49:29Z")
TRANSACTIONS What are Transactions and how and when should I consider using them? What is good practice in designing a Transactions feature? --- ## [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… --- ## [Performance core principles: 12. Plugins](https://the.fmsoup.org/t/performance-core-principles-12-plugins/1873)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 4\ **Last updated:** [March 12, 2021, 2:06pm UTC](https://the.fmsoup.org/t/performance-core-principles-12-plugins/1873 "2021-03-12T14:06:50Z")
PLUGINS Which plugins can enhance FileMaker performance without thereby introducing dependencies which create maintenance issues in the future and how should be best use those plugins? --- ## [Performance core principles: 13. Miscellaneous](https://the.fmsoup.org/t/performance-core-principles-13-miscellaneous/1874)
**Author:** [@nicklightbody](https://the.fmsoup.org/u/nicklightbody)\ **Replies:** 13\ **Last updated:** [March 14, 2021, 7:08pm UTC](https://the.fmsoup.org/t/performance-core-principles-13-miscellaneous/1874 "2021-03-14T19:08:38Z")
MISCELLANEOUS Please be rigorous (ie think for maybe 5 seconds first) and try to submit your responses, disagreements, expressions of support and questions under the correct Performance thread / topic. However, if you…