Magento 2 & Hyvä articles tagged “EAV”: hands-on tutorials, fixes, and guides from Kishan Savaliya, an Adobe-certified Magento developer.
3 articles
InstallData is dead. This is the data patch pattern I ship to client stores: one class, dropdown options, attribute set assignment, and a patch_list war story from a live deploy.
After a 2.4.7-p3 to 2.4.8-p3 upgrade, setup:upgrade throws 'Cannot instantiate interface AttributeRepositoryInterface'. The root cause is stale compiled DI. Here is the exact recovery recipe plus the extension audit to run if it returns.
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. After tuning 22 catalogs between 8k and 180k SKUs in 2025-2026, only three remediations consistently bring category page TTFB back under 250 ms: 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.
