This article provides recommendations on using coupons funtionality in Magento Commerce and Magento Commerce Cloud, aimed at avoiding performance issues.
Affected products and versions
Creating a large number of coupons could lead to performance issues. Magento recommends keeping the number of coupons in your database (that is the number of records in the
salesrule_coupon DB table) below around 250000.
Following approaches will help you in keeping the number of coupons within recommended limit:
- Remove coupons if they are not needed any more.
- Generate the exact number of coupons needed to meet the 'discount' campaign needs.
Coupon codes in Magento User Guide.