Filemaker slow, bogged down
I now have a lot of related tables, with a lot of calculated fields [but no summary fields], with new windows opening with portals, etc.
... But not a lot of records. Max of 200 or so in the largest table.
Understanding this is an extremely broad overview ...
Opening the database now takes around ten seconds.
For a new window to open it takes at least the same, and the refresh [ie records being loaded] can be watched almost record-by-record.
Am concerned I've loaded the system down. It's not the hardware [Core i7, 16gb's ram, etc].
Again, this is an extremely broad overview, but does anyone have some direction in this regard?