Insights on engineering, technology, and business strategy
Showing 3 articles in Case Studies
A ClickHouse materialized view cutover dropped per-fire memory from 140 MiB to 7.4 MiB. The cluster's resident memory didn't move a byte. Here's the SQL pattern that made it work, and the more important lesson about which memory metric actually predicted our OOM exposure.
Dashboard timeouts during winter storms. 45-second queries when road crews need real-time data. We moved 1.3 billion IoT rows from SQL Server to ClickHouse Cloud—and cut query times from seconds to milliseconds while saving $2,200/month. Here's exactly how.
In just six months, we transformed a client's struggling weather monitoring platform from a liability into their strongest competitive advantage