Wide rows
Difficulty 4 of 5
A large chat account has ten million messages. Each request asks for the latest 50. All messages of one user sit in one partition that keeps growing. Keep p99 below 100 ms.
Hash ring · 3 to 4 nodes · 8 of 36 keys move
Goals and limits
- p99 latency
- under 100 ms
- Monthly cost
- under 100 USD/mo
- Parts you can add
- Wide-column DB
- Part limit
- 16
- Traffic
- 500 req/s
Concepts
How players did
Player results load from the server.