Denormalize

  • Choose
  • Store 13

Difficulty 2 of 5

Each feed request needs six indexed lookups. Users read feeds 2,000 times/s, and 1 percent of requests change a feed. A change must show in the feed within 1 s. Choose how to serve feeds. Keep p99 below 150 ms.

Play level

Options

  • Run six source lookups on every read
  • Cache each joined feed for 60 s
  • Read one prepared feed, updated on each write
Tables join, documents copyTap or press Space to switch between tables and documents

Goals and limits

p99 latency
under 150 ms
Data age
under 1 s
Monthly cost
under 100 USD/mo
Traffic
2,000 req/s

Concepts

How players did

Player results load from the server.

All levels