Performance issues - how to tackle? Can I force re-calculation of STORED calculated fields?
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?