HardDesign: Social Media Platform (Instagram)

How is the like count for a photo stored and retrieved at 49,000 likes/sec?

Tests your understanding of this concept.

Answer Options

ADirectly in SQL posts table, updated per like
BRedis INCR for fast atomic increment, batch-written to SQL DB every 5 seconds
CCounted by querying likes table at read time
DStored in Elasticsearch for fast aggregation

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 22+ more Design: Social Media Platform (Instagram) questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the Design: Social Media Platform (Instagram) topic (System Design Cases).

More Design: Social Media Platform (Instagram) Questions