Caching results of formulas during a select

[DaPi]

Looks like for this relatively simple formula, the cost of the function call is comparible with the evaluation of the function. In a complex case it might not be so "bad". (P.S. padders is pointing out that I'm being naïve here)


I'm a little concerned about the logic of your process (it could be that you have over-simplified it for posting here):

- After running it measurement1 is replaced by f1(original_measurement1). If you run it again, it would be replaced by f1(f1(original_measurement1)). Should you have a DONE<>1 condition in the cursor?

- I would argue against over-writing the original measurement with a derived value. On philosphcal grounds and the practical grounds that if you preserve the original value, it's much easier to sort things out if you have an "accident" with the calculations.