I have a problem with aggregating data in one table. Without caching it takes around a minute, so I've decided
So everything seems to be going great, but I have a small question. Our backend is inserting data to the main table, lets call it "A". My pre-aggregated table "A1" is being created by cron job and is populated in midnight. But what about after? Do i just insert the data twice into two tables?
So everything seems to be going great, but I have a small question. Our backend is inserting data to the main table, lets call it "A". My pre-aggregated table "A1" is being created by cron job and is populated in midnight. But what about after? Do i just insert the data twice into two tables?