Stored Calc vs. Stored Text/Number Field

Discussion created by taylorsharpe on Mar 30, 2013
Latest reply on Apr 1, 2013 by DaveRawcliffe

One of the fun features of FileMaker are the calculation fields since they are not apart of most SQL databases. We all know the achiles heel of calculation fields being the unstored calculation field. But I have wondered about optimizations. Would doing a lookup or auto entered and stored normal fields performance be faster than a stored calculation field? Do they perform the same or, if not, which is the faster way to go. Basically, I was trying to figure if to optimize things I should also avoid stored calculation fields or not. Thanks for any input of your experiences.