Epic: Performance Optimisation

[Snider]

Overview

Eliminate performance bottlenecks: fix N+1 queries, remove unbounded ::all() calls, and add HTTP caching headers.

Children

• performance(queries): fix N+1 queries in ConfigResolver, AdminMenuRegistry, activity feed, SeoScoreTrend #88 — performance(queries): fix N+1 queries in ConfigResolver, AdminMenuRegistry, activity feed, SeoScoreTrend
• performance(queries): replace ::all() with chunking/cursors #89 — performance(queries): replace ::all() with chunking/cursors
• performance(http): add caching headers middleware #91 — performance(http): add caching headers middleware

Previously Created (existing)

• Performance: selectRaw queries may have missing indexes #19

Exit Criteria

No N+1 queries in listed areas. No unbounded ::all() calls. Caching headers set for all public routes.