My db is very small from a records standpoint (60 records). However, there are 2 big tables that contain 65 calculation fields in each. Of the 65 calculation fields in each table, 30 are summary calculations that cannot be stored and the majority of the other fields cannot be stored as well, since they are related to the summary fields. There is also 1 field in each table that sums the total of the summary fields.
There is roughly a 2-second delay in switching from one layout to the next on my local computer. When I deleted the grand sum field that sums the summary fields, the delay dropped down to about 1-second. I do wish to keep that grand sum though.
Any thoughts on how to overcome all the summary fields (the sum is required) - is there a better way to improve performance?