AnsweredAssumed Answered

Calc fields -- stored vs. unstored

Question asked by firth5 on Nov 14, 2011
Latest reply on Nov 14, 2011 by philmodjunk


Calc fields -- stored vs. unstored


Hi There,

My database has been slowing down recently, and I've been advised to take a look at summary and unstored calc fields.

I've found plenty of unstored calc fields.  I chose to use them unstored because the user guide says that "you can tell FileMaker Pro to perform the calculation only when needed (unstored)."  I have a script that calcs a report once per day, so I figured that unstored was the way to go.

My question is, if I change all the calc fields to STORED, when do the calc fields compute?  every time you enter data (even if the field is not displayed on the layout)?  or only when the field is displayed on a layout?


Thanks in advance.