Kuldeep Upreti

I think this should be done automatically by wordpress right? Do I need to create an Index for meta_key column?

I executed the query directly on the database. It took around 3 seconds to execute the query.

Here is a JSON for the result, when the query is executed with addition of EXPLAIN before it.

{
“id”: 1,
“select_type”: “SIMPLE”,
“table”: “wp_postmeta”,
“partitions”: null,
“type”: “range”,
“possible_keys”: “post_id”,
“key”: “post_id”,
“key_len”: “8”,
“ref”: null,
“rows”: 191841,
“filtered”: 100.00,
“Extra”: “Using index condition; Using filesort”
}

A single query takes around 10 seconds to complete. We monitored this by monitoring tool – New Relic. Currently, we have 3 auto-coupons in the system.

Yes, the ‘high performance’ mode is enabled on the plugin settings.

Yes, it is hapenning same for me. Is there a solution from plugin developers?