divinebox

Hello,

I have cleared all completed action Scheduled Actions from tables, and

1. the query are still there
2. but they are wayyyyy lighter : time went from ≈ 0,2s to 0,001s

So i guess that solved the problem. Thanks a lot !

Hello,

Have you been able to look at this please ? Do you have a fix ?

Thanks

Hi,

Can you help please ?

The plugin Query Monitor still shows me this query at every page load, and it’s the heaviest for my back-end. Why is it loaded ?

Thanks for your help,

Resolved ?

Hello, I have updated the plugin to the version 5.69.0, and I don’t see the query executed anymore. Thanks a lot !

Hello,

I have updated the plugin to v5.7.9, and have enabled the option : Hide Subscriber Count (Admin Side). There is no counter on Admin Side, indeed, but :

1. i didn’t have the problem at the time ?? (see first screenshot)
2. the query still executes (see screenshot here below)

Can you dig further please, to avoid the query to execute ?

Thanks

The plugin “query monitor” shows that it can be a quite heavy query for me, which slows down my admin pages. Could you introduce an option to activate/deactivate the counter please ? Or give a small snippet for functions.php ?

Thanks a lot,

Hi,

You write “The plugin being activated is all that is needed for the scheduled actions to run so that the reminder emails are sent” ,

… but the plugin “Query Monitor” shows a heavy/slow query for on EVERY admin page that i open, that belongs to your plugin

The query is :

SELECT a.action id
FROM mod272_actionscheduler_actions a
WHERE 1=1
AND a. hook=’woocommerce_ac_send_email_action’
AND a.status IN (‘pending’)
ORDER BY a.scheduled_date_gmt ASC
LIMIT 0, 1

Why is that ? Is this query necessary at every admin page load ?

Thanks a lot,

Hi,

I don’t see the notification to click on to dismiss anything ?? Is this normal ?

Moreover, here is more details on this query. Does it help ?

But indeed, having a query this heavy (maybe because of the number of reviews – 23k – that i have) is not necessary at all.

Could you provide me with a simple hook / modification to avoid it please ? (hoping you’ll update the plugin soon as well ;-))

thanks

But with action scheduler, the reminder emails should be sent by defaut (on the backround i mean, without any admin action, or page load). Why do you require that the load of any admin page triggers the sending of the emails ? ?? Cannot this be autonomous ?

In that way, we could avoid some queries to improve back-end speed performance.

Let me know if that’s not clear enough. Thanks !

But is this necessary to call this hook/query on all pages of the admin panel ? For instance, it is called :

• on the order edit page
• on the plugins list

… and it seems to me that this is not necessary here. Do you confirm ?

thanks for your help,

Me too. Just following

Looks good, thanks. When will the plugin updated with this filter ?

I confirm, it’s OK now. Thanks!

Today : 250. But in the future i may want to be able to put 300 or 400.