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