A 4,000-SKU store on shared hosting in Sydney
Category pages went from 8.4 seconds to 1.6, without a bigger server
- The situation
- Checkout worked, but category and search pages took eight seconds or more at any traffic. Two hosts had already recommended a larger plan.
- What we found
- A faceted-filter plugin was running an unindexed query across the full product table on every page render, then discarding most of the result. Server load was a symptom, not the cause.
- The decision
- Fix the query before touching the hardware. We rewrote the filter to use indexed lookups, added an object cache for the term counts, then migrated to Auckland for the latency win.