Denormalize

Store 13

Choose

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.

Goals

Not tested yet

99 of 100 requests finish faster than this.How old the data is when a reader gets it.What the servers and services cost each month.
Choose a design
Run six source lookups on every read
Cache each joined feed for 60 s
Read one prepared feed, updated on each write

Tap a part to add it, or drag it onto a trace.Click a part to add it, or drag it onto a trace.