The vocabulary question hiding real depth: which primitive replaces ORDER BY, why sharding by player is wrong, and what a 45,000 updates-per-second storm actually costs.
an account raises the per-topic limit · no card
← DevOps System Design & Architecture / 15
easyNewFlipkartPhonePeSwiggy
Design a real-time leaderboard for a mobile game with ten million daily players.
The vocabulary question hiding real depth: which primitive replaces ORDER BY, why sharding by player is wrong, and what a 45,000 updates-per-second storm actually costs.
Updated Sep 2026 · Grounded in researched DevOps, SRE and platform engineering interview loops, written to a senior-engineer editorial bar, and never padded to hit a word count.
UP NEXT ON YOUR JOURNEY
Next in this trackDesign notifications for a food delivery app. Order updates cannot be late; coupon blasts cannot spam.Next in this trackDesign a feature flag service used by 200 services. Why keep ordinary evaluation off the network path?Next in this trackPostgres is out of headroom. How do you choose a shard key, and how do you reshard later without downtime?
DISCUSSION · 0
Nothing here yet. Say how you would answer it.