The Battle for Milliseconds: How to Optimize Heavy Filtering in catalog.section

A practical guide to speeding up heavy filtering in catalog.section on million-SKU catalogs — from pinpointing bottlenecks with the performance monitor and EXPLAIN to filtering by iblock properties via subqueries in D7 ORM with split-storage support, subsection collection via Nested Sets, tagged caching, and hand-tuned MySQL indexes.

FEEDBACK

Email me

Please message me to discuss the task. I work remotely and officially (as a self-employed professional); my hourly rate is 1,800 RUB, and I can dedicate 3–4 hours a day to the project. I respond quickly, and the consultation is free.

An error occurred while sending, please try again after a while

Message sent successfully

Phones

+7(993) 007-18-96

Email

info@tichiy.ru

Address

Россия, г. Москва

By submitting the form, you automatically confirm that you have read and accept the Privacy Policy site