Answers to the question you searched for, with the numbers attached.
-
Deep dive
From 26 minutes to 8 seconds: replicating a legacy export
A finance team downloads a spreadsheet every morning that a vendor's legacy system builds with about 82,000 queries in 26 minutes. I rebuilt it with 9 queries in 8 seconds, and proved it equal cell by cell before anybody relied on it.
measured ▸ 26 min → 8 s · ~82,000 queries → 9 · 862,297 fields compared, 0 divergent · 515,530 cells 100% identical
-
Deep dive
Billing-grade telemetry from 15,000 devices
Every ad play is billing evidence, and the screens lose the network for hours. How the proof-of-play pipeline works: cache on the device, batch uploads, sort before insert, a weekly-partitioned MySQL with 2 billion rows, then Kafka and ClickHouse.
measured ▸ ~200 million play rows a day · importer runs of 155k to 643k rows in 7 to 20 s · MySQL era: 2B+ rows, weekly partitions