Re: Using rollup tables to aggregate data in large datasets
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.
Subject
Views
Written By
Posted
8858
July 16, 2013 04:18AM
Re: Using rollup tables to aggregate data in large datasets
2659
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.