This article provides recommendations on using coupons functionality in Magento Commerce and Magento Commerce Cloud, aimed at avoiding performance issues.
Affected products and versions
Creating many 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.