2 ms·
I wonder why they used a database at all: "These records are then read out once at the end of the day, summarised and then very rarely touched again." And late
by MichaelGG 17y ago
I wonder why they used a database at all:
"These records are then read out once at the end of the day, summarised and then very rarely touched again."
And later on they end up writing them to a text file and bulk inserting them in 10K batches. Wouldn't it be easier to just write them all to a file then summarize at the end of the day? (It also says they do a DROP TABLE on each day's data.)