# Simple Development question

**URL:** <https://forum.servoy.com/t/simple-development-question/3036>\
**Category:** Classic Servoy\
**Created:** [November 9, 2004, 5:28pm UTC](https://forum.servoy.com/t/simple-development-question/3036 "2004-11-09T17:28:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ebrandt](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ebrandt](https://forum.servoy.com/u/ebrandt)\
**Post date:** [November 9, 2004, 5:28pm UTC](https://forum.servoy.com/t/simple-development-question/3036/1 "2004-11-09T17:28:07Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![bcusick](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bcusick](https://forum.servoy.com/u/bcusick)\
**Post date:** [November 9, 2004, 5:32pm UTC](https://forum.servoy.com/t/simple-development-question/3036/2 "2004-11-09T17:32:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ebrandt](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ebrandt](https://forum.servoy.com/u/ebrandt)\
**Post date:** [November 9, 2004, 5:37pm UTC](https://forum.servoy.com/t/simple-development-question/3036/3 "2004-11-09T17:37:25Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bcusick](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bcusick](https://forum.servoy.com/u/bcusick)\
**Post date:** [November 9, 2004, 5:41pm UTC](https://forum.servoy.com/t/simple-development-question/3036/4 "2004-11-09T17:41:56Z")

</div>

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

Unstored do not (held in memory only).

Unstored = faster.

![:-)]( "Smile")

Bob