Simple Development question

[ebrandt]

This is the performance differernce this creating a calculation stored, unstored or on the fly using variables. I am trying to determine when is the best case to use the correct scenario. What are some typical examples when these stratgies are used.

[bcusick]

This is "Bob's Personal Theory":

1) Used STORED calcs only when you need to search or sort by a calculated value.

2) Use UN-STORED for everything else.

Bob

[ebrandt]

Bob,
Thanks for the hep. I have alot of stored calcs, when I start running reports I figured I can run the query based on several tables, and display as html, without having to add more calculation coding.

I guess my main question is, is there a disadvantage having stored calcs?

Thanks,
Erich

[bcusick]

Stored calcs have to make a database call (query) to update the value.

Unstored do not (held in memory only).

Unstored = faster.



Bob