cmj

Speed Up Summary Field Values

Discussion created by cmj on Jan 3, 2018
Latest reply on Jul 8, 2018 by jbrown

Just a thought on how I can speed up some calculations when going to a related layout...

On Layout2 there are a large number of fields that are summary fields of numerous calculation fields within Layout2's table (Table 2).

Layout 1 displays  summary fields from Table 2. Layout 1 is very slow responding because there are many many calculations in Table 2 that must be re-calculated.

I'm considering making a new table (Table 3) where I write the values of the summary fields from Table 2  (via script) upon exit of Layout 2. I would make those values as "stored" in Table 3.

Layout 1 would display the stored values from Table 3 instead of forcing all the calculations from unstored values in Table 2.

Would this result in a speed increase when opening Layout 1?

Thank You

Outcomes