Storing "derived" values vs calculating them on extraction
- by kemp
When you have values which only depends on one or more other fields +/- constants (say retail price & discount price), is it better to store those values too or to calculate them "on the fly" when retrieving the data?