Optimized Performance → Cut p99 280ms: Backend Bullets With Proof

Free · No signup · Recruiter-reviewed

Replaced two filler nouns ('performance', 'overall system efficiency') with the actual query path, the actual percentile, and the actual remediation. Senior engineers always speak in p99 / p95, never 'overall efficiency'.

Cut checkout API p99 from 420ms to 140ms by rewriting the inventory join and adding a covering index on order_items.

What changed and why

  • p99 > p95 > average. Recruiters and staff engineers know average masks the tail — quoting p99 signals seniority.
  • Name the endpoint (checkout API), the table (order_items), and the technique (covering index). Three concrete nouns beat any adverb.
  • If you remember the before-and-after numbers, you did the work. If you only have 'improved performance', you watched someone else do it.
  • Database fixes that survive are usually index changes or denormalisation — both are defensible in a system-design round.

Recruiter perspective

“p99 280ms cut, named the join, named the index. This is a real staff-eng artifact.”

— Principal Backend Engineer · FinTech

Related rewrites