Stabilizing legacy PHP under load
Production ran on legacy PHP: fine on quiet days, timeouts and complaints during sales. A full rewrite did not fit time or budget.
Inspected slow queries, N+1, missing cache on public lists, fragile SQL. Fixed by impact: indexes, batching, fragment cache, safer queries. Release without taking the storefront down.