Skip to content
Blog tag

#MySQL

Magento 2 & Hyvä articles tagged “MySQL”: hands-on tutorials, fixes, and guides from Kishan Savaliya, an Adobe-certified Magento developer.

1 article RSS feed

Related tags: #Magento Performance #Core Web Vitals #Lighthouse #Magento 2 #Magento 2.4.9 #Indexing

Performance topic art

Posts tagged MySQL

Page 1 of 1, newest first
  • Performance

    Magento Slow Category Page: The Indexer, EAV & JOIN Trap

    Most Magento 2.4.9 stores hit a visible wall the moment a category crosses ~5,000 products. The price index swells, the EAV join fan-out balloons, and a category that rendered in 400 ms now takes 1.8 seconds before TTFB even starts. Only three remediations reliably bring category page TTFB back down: legacy flat catalog (yes, deprecated, still works under 50k SKUs), the Hyvä Catalog add-on, and a custom slim query for SKU-only listings. Here is the EXPLAIN ANALYZE for each, the millisecond numbers, and the SKU ceiling for each option.

Stuck on this? Share the issue or question Ask about your store