Illustrative scenario. Metrics are examples, not verified client results.
Context
An order API slowed as the catalogue grew.
Challenge
N+1 database calls and blocking I/O inflated tail latency.
Approach
Profile representative requests, batch queries, tune indexes and introduce output caching. Verify with load tests.
Illustrative result
2.4s → 180ms — an illustrative value to be replaced with verified data before publication as a client result.
Tech stack
.NET · PostgreSQL · OpenTelemetry