Slow queries

I also got duplicate quesries from your plugin here:

‘%wp_5_wt_sc_coupon_lookup%’ Wt_Smart_Coupon::is_table_exists() 2 calls

Hi @stylingagenten,

Greetings from WebToffee support.

The slow query warning you mentioned in the screenshot is due to the auto-apply coupons on your site.

The plugin inspects for five valid coupons at a time instead of checking all coupons at once to avoid additional load on your site. If there are no valid coupons during the first check, it will then check the next 5 auto-apply coupons. And this is continued until all auto-coupons are checked.

You may disable the Apply coupon automatically from unwanted coupons to reduce the issues with queries.

Regarding your second query, we have been able to detect the duplicate queries on the My account page. We will be addressing this issue and optimizing it in the next release of the plugin.

Thank you for your understanding.

Thanks for you help!

Regarding the auto-apply coupons, I do only have one code activated for that in my store. It is when they purchase over an amount then they will get a free product. You mean that there is possible more coupons that have that settings? I do have almost 10.000 coupons, is it a way to know what coupons without check one and one:)

Have a great day!

• This reply was modified 1 year, 3 months ago by Andreas.

Hi, do you have any feedback regarding this?

Hi @stylingagenten,

If you have access to the site’s database, you can view the number of coupons with auto-apply, from the post_meta table. You may search using _wt_make_auto_coupon key. The coupons with value 1 will be have the Apply coupon automatically enabled. Else, you may have to check them one by one.

Alternatively, you can limit the number of auto-coupons on your site using the code snippet from here. You may change the value to 1 or 2 as per your requirement.