![]() The Invoice Lines table has a field called Totals - this is an unstored calculation with the formula Quantity * Price. Let’s say we have a database with an Invoice and Invoice Lines table. The good news is - you can improve slow FileMaker performance with this data caching trick. It may be easier to use unstored calculations in order to get your database functionality working, but this will inhibit your system from scaling with your business in the long run. They must calculate the data each time the field is displayed. Just as the names indicate, “unstored” calculation fields and “summary” fields don’t store any data. If you have unstored calculation or summary fields on your layout, this will most certainly be the issue. ![]() Have you ever wondered, “What is taking this report so long to generate?” or “Why does this layout take so long to load?” It may be that your FileMaker fields are set up inefficiently. WordPress Repair and Troubleshooting Servicesĭogged by a Slow FileMaker Database? Cache in on this Quick Tip to Improve Layout Load Times & Report Generation.WordPress Maintenance & Support Packages.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |