Problem
Paradox Shop's order-history API now takes 800 RPS, but its three application servers were sized for a much smaller launch and are already over capacity. Its 40-million-row orders table is indexed on customer_id from the last time this happened, but a newer recent-orders dashboard filters by created_at and is back to a full table scan. Scale the app tier to the real traffic, and add the index that dashboard query needs.
Required components
Click to add a component to the canvas.
Additional components
Browse by category. Click or drag a component onto the canvas.