Question

Difference between calculated Attribut and stored attribute

0

Hello Experts While creating attributes in Data Model I have to select one of the two 1. calculated Attribute 2. stored attribute what is the difference between the two. Regards Shanmukha Rao Banisetti

asked 2018-11-01

Shanmukha Banisetti

3 answers

Dragos Vrabie · Answer 1 · 2018-11-01

Hello Shanmukha,

The calculated attribute doesn't get stored in the database, instead every time you retrieve an object it gets calculated.

There are valid use case scenarios for calculated attributes, but generally I suggest you avoid calculated attributes as they can bog down your app easily when working with large sets of data.

Hope this helps.

Paul Ketelaars - Deprecated · Answer 2 · 2018-11-01

A stored attribute is an attribute which value is stored in the database.

A calculated attribute (or Calculated Value) is an attribute which value is calculated EVERYTIME the object it is in, is used.

Jelte Lagendijk · Answer 3 · 2018-11-01

Have a look at the academy (use search in the top right), there are a few sections about the difference between calculated and stored attributes.