MySQL Forums
Forum List  »  Data Warehouse

Re: Using rollup tables to aggregate data in large datasets
Posted by: Rick James
Date: July 21, 2013 01:10PM

Good article.

Note, however, that the one-at-a-time UPDATEs will bog down when their frequency exceeds about 100 per second.

This discusses how to carry it to the next level:
http://mysql.rjweb.org/doc.php/datawarehouse
(Alas, it does not discuss how to do both the decrement and increment.)



Edited 1 time(s). Last edit at 07/21/2013 04:01PM by Rick James.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Using rollup tables to aggregate data in large datasets
2222
July 21, 2013 01:10PM


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.