Optimize Magento 2 Cart Price Rules Performance

This technical guide explains why Magento 2 cart price rules can severely impact checkout performance and provides measurable, database- and application-level optimizations. It describes the costly validation cycle that runs on every cart change (loading active rules, evaluating conditions, checking coupons, recalculating discounts), how to measure validation time (example profiling plugin and MySQL slow query checks), and concrete mitigations: combine rules, simplify conditions, prefer catalog rules or index-time pricing for per-product promos, use coupon prefixes, add compound indexes on salesrule_coupon, clean expired coupons, tune salesrule_product_attribute indexes/partitions, disable unnecessary quote recollects, and use caching/ESI or offload calculations to a dedicated cart service. The article includes a real-world case study showing large reductions in active rules, coupon rows and cart validation latency after applying these techniques.