Database Throughput
Database hot-path tuning
Find the queries and access patterns that steal headroom during busy hours, with fixes that survive the next content drop.
Overview
We trace read/write amplification around inventory, progression, and social graphs. Recommendations favor index hygiene, bounded aggregates, and safer batching over one-off hardware spend.
Duration: 5 weeks · Format: Remote · Investment: KRW 32,000,000
Included focus
- Slow query corpus tagged by gameplay feature
- Index plan with rollback notes
- Cache boundary suggestions with staleness budgets
- Migration ordering when multiple services touch the same rows
- Load test hooks your DBAs requested
Outcomes
- Measured candidate queries with expected risk
- Two deep-dive pairing sessions with your DBAs
- Written guardrails for future schema reviews
Point consultant
Noah Andersson
Data infrastructure consultant focused on OLTP under gaming workloads.
FAQ
Never directly. We pair on statements and review plans; your team applies changes.
Experience notes
Database hot-path tuning surfaced a fan-out we had hand-waved for two seasons.
Wish we had booked an extra week for stored procedure cleanup—that part is still on us.