MySQL Forums
Forum List  »  Performance

Re: To store or calculate on the spot?
Posted by: John Nahlen
Date: July 23, 2011 10:08PM

If I may...

Updating the summary would basically be like calculating on the spot... it would require extra I/O operations and the like.

How often are you actually going to need the data for reports and such? I would recommend just telling the users "Results cached for 3 hours" or something. Once again, the topic of speed (cache) vs realtime data (accuracy) comes up.

I hope this helps.
- John

Options: ReplyQuote


Subject
Views
Written By
Posted
3311
July 23, 2011 09:15AM
Re: To store or calculate on the spot?
1215
July 23, 2011 10:08PM
1090
August 10, 2011 07:22PM
1152
August 11, 2011 07:52PM
1006
August 12, 2011 07:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.