I have a relativly large FM DB (FMS 16.03 + Clients), 1 gig total, with 2 main tables that have ≥ 800,000 records. No Containers, just data.
My issue: When importing data into one of the large tables, a SUMMARY FIELD calculation keeps recalculating and slows the entire process down to a crawl. The SUMMARY FIELDS are NOT even on the current layout, which confuses me since I don't see why its recalculating when NOT being displayed or even on the current layout table.
Thoughts on how to get around this would be appreciated.
Also thoughts on AVOIDING Summary Fields would be great too....