Any attribute

  • Build
  • Store 14

Difficulty 2 of 5

One million products have attributes that change by product type. Each query filters on three nested attributes and returns 20 products. Keep p99 below 150 ms.

Play level

SQLUsers1,000 req/sPostgres2 vCPU · 2 GB
SQLUsers1,000 req/sPostgres2 vCPU · 2 GB
The board at the start of the level
Tables join, documents copyTap or press Space to switch between tables and documents

Tables · a read touches 3 places in 0.5 ms · a shared change writes 1 place

Goals and limits

p99 latency
under 150 ms
Monthly cost
under 100 USD/mo
Parts you can add
Postgres, Document DB
Part limit
16
Traffic
1,000 req/s

Concepts

How players did

Player results load from the server.

All levels