Simple Development question

Classic Servoy
1

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.

2

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

3

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

4

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

Unstored do not (held in memory only).

Unstored = faster.

:-)

Bob