Storing Calculated Fields

[djcapslock]

Hi,

I am producing a database which does some statistical calculations, so far I have been storing results of upper quatiles and lower quartiles of results as the calculations seem to take a little while to do is this the right approach?

Thanks

David

[ck9663]

Hi,

I am producing a database which does some statistical calculations, so far I have been storing results of upper quatiles and lower quartiles of results as the calculations seem to take a little while to do is this the right approach?

Thanks

David

if these are simple calculations that can be calculated on the user-end, try doing it on the user-end and see the difference. if this value is frequently read and displayed, and takes time (summarization) to produce, i would recommend to create a new field for this. don't stress your processor. drives are cheaper than processors.your pros (faster execution) outweighs the cons (additional space on disk)