Rows or columns

  • Choose
  • Flow 07

Difficulty 3 of 5

The shop database answers 4,000 queries/s with 8 vCPU. A new dashboard runs 5 queries/s. Each query sums 2 columns over 200 million order rows. Choose where the dashboard runs. Keep shop p99 below 50 ms and dashboard p99 below 2 s.

Play level

Options

  • Query the shop database
  • Query a read replica of the shop database
  • Query a columnar analytics store
A disk that fillsArrow keys change the write rate. Tap to ship the logs.

Goals and limits

p99 latency (Shop)
under 50 ms
p99 latency (Dash)
under 2 s
Error rate (Dash)
under 1%
Monthly cost
under 1,000 USD/mo
Traffic
5 req/s

Concepts

How players did

Player results load from the server.

All levels