How Big Tech Scales View Counts: The Power of HyperLogLog and Harmonic Means
TL;DR: Scaling unique view counts for millions of posts requires more than just a COUNT(DISTINCT) query. Modern platforms use HyperLogLog, a probabilistic data structure that estimates cardinality usi
Mar 18, 20266 min read4
