Practice
Learn
← Quit
0 / 0 correct
System Design
Hard
1 of 640
Design Slack-style 'unread counts' across thousands of channels per user. What is efficient?
A
Count unread messages with a COUNT(*) query per channel on every page load
B
Recompute nightly
C
Store a row per (user, message) unread flag
D
Store each user's last-read sequence per channel and compute unread as latest_seq − last_read, caching per user