AnsweredAssumed Answered

Performance issues - how to tackle? Can I force re-calculation of STORED calculated fields?

Question asked by Donovan_1 on Apr 7, 2014
Latest reply on Apr 12, 2014 by philmodjunk

Title

Performance issues - how to tackle? Can I force re-calculation of STORED calculated fields?

Post

     It looks like I have some performance issues. Editing a table containing some heavy calculated fields - some of them using ExecuteSQL() - introduces some noticeable lag.

     I changed the Calculated Fields to STORED and the editing was lightning fast.

     As I do not expect those calculations to be subject to lots of changes, could I let them be STORED and is there a command to force recalculation of these STORED calculations in case I know something changed that influences these fields?

Outcomes