Problem
Checkout now serves 600 requests/second, joining an order's Orders row with its Order Items rows. Orders is sharded by order_id, but Order Items is sharded by its own row id, so a checkout query has no way to know which shard holds a given order's items and has to fan out across the whole cluster. Resize the app tier, and repartition Order Items so a single order's rows always land on the same shard.
Required components
Click to add a component to the canvas.
Additional components
Browse by category. Click or drag a component onto the canvas.