Conversation
supportThis plugin is causing huge server load slowing down our site, we have no choice but to delete it. This topic was modified 2 months, 3 weeks ago by e4deal .
Hi @e4deal , Sorry to hear you’re seeing load issues. Auto Coupons for WooCommerce is designed to avoid “scan every coupon on every page view” behavior, but it does need to evaluate eligible coupons when cart activity happens. On stores with a sudden large volume of visitors, or large number of coupons (especially lots of auto-apply / URL-apply / restricted coupons) that translates into heavier database work, and on basic hosting it can show up as high server load. If you want, I’m happy to help confirm whether it’s configuration vs hosting limits. Please share: Total coupon count How many are set to auto-apply and/or apply via URL Hosting type (shared/VPS/dedicated) PHP + MySQL version
We currently have approximately 7,200 coupons in the system. However, 99.9% of these have not been used since 2023. We only have 3 or 4 coupon uses per day. We have three coupons configured for auto-apply, and none of them are currently active or in use. The site is hosted with Kinsta, running PHP 8.2.
Hi @e4deal , Thank you, that is helpful detail. Knowing this, I’ve released v3.0. 44 today with potential efficiency improvements. Expired coupons are excluded earlier in the root query, and coupons with email restrictions are no longer evaluated unless specific features are turned on, which should reduce load on large coupon datasets. If performance issues continue, I recommend ensuring old coupons have an expiration date set or are moved out of published status. Please update to 3.0.44 when you have the opportunity and let me know if any improvement is observed.
Hi @e4deal , Sorry to hear you’re seeing load issues. Auto Coupons for WooCommerce is designed to avoid “scan every coupon on every page view” behavior, but it does need to evaluate eligible coupons when cart activity happens. On stores with a sudden large volume of visitors, or large number of coupons (especially lots of auto-apply / URL-apply / restricted coupons) that translates into heavier database work, and on basic hosting it can show up as high server load. If you want, I’m happy to help confirm whether it’s configuration vs hosting limits. Please share: Total coupon count How many are set to auto-apply and/or apply via URL Hosting type (shared/VPS/dedicated) PHP + MySQL version
We currently have approximately 7,200 coupons in the system. However, 99.9% of these have not been used since 2023. We only have 3 or 4 coupon uses per day. We have three coupons configured for auto-apply, and none of them are currently active or in use. The site is hosted with Kinsta, running PHP 8.2.
Hi @e4deal , Thank you, that is helpful detail. Knowing this, I’ve released v3.0. 44 today with potential efficiency improvements. Expired coupons are excluded earlier in the root query, and coupons with email restrictions are no longer evaluated unless specific features are turned on, which should reduce load on large coupon datasets. If performance issues continue, I recommend ensuring old coupons have an expiration date set or are moved out of published status. Please update to 3.0.44 when you have the opportunity and let me know if any improvement is observed.