medium10 pts · first answer countssystem-designdatabaseshot-spots
A like counter on a viral post
A viral reel gets 20,000 likes per second, all doing UPDATE posts SET likes = likes + 1 on one row. Writes time out. What is a common fix?
Discussion 0
Join free to post in the discussion.
Related questions
- Building SQL from user inputBackend Developer
- What atomicity guaranteesBackend Developer
- WHERE column = NULL finds nothingBackend Developer
- COUNT(*) versus COUNT(column)Backend Developer
- Column type for pricesBackend Developer
- Storing order times for two countriesBackend Developer
- Students and courses table designBackend Developer
- What a foreign key doesBackend Developer