Slow backend (useless query : ActionScheduler_DBStore->query_actions())

Hi @divinebox, The hook is important because it is responsible for sending the abandoned cart reminder emails. I wouldn’t advise deactivating the hook, as it is a key component of our plugin and also the action scheduler.

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,

@divinebox so the thing is that we can’t run that hook/function on specific admin pages because the scheduled action only runs once when the plugin is activated. If we add a condition for specific pages and that page doesn’t open, the reminder emails will not be sent.?

I hope this helps.

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 !

@divinebox we do not necessarily require the full load of any admin page trigger before the reminder emails are sent. The plugin being activated is all that is needed for the scheduled actions to run so that the reminder emails are sent.

Can you confirm if that answers your question about making it autonomous?

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,

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,

Hi @divinebox we’re still checking the query you singled out along with every other hook working with it. I’ll give you an update as soon as we’re done.

@divinebox just as I have mentioned in previous messages in the thread, we can’t disable/stop our ‘woocommerce_ac_send_email_action’ action scheduler because it’s running in the background to send reminder emails.

I have also run multiple simulations on my end, and it doesn’t take time to load on pages. Can you check the scheduled actions part in the WP admin, clear all completed action Scheduled Actions from tables, and then check? Clearing all pending actions will significantly increase the speed and load time.

Let me know how this goes.

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 !

Thanks for the confirmation, @divinebox. As I mentioned earlier, the query will still be there, and this is because the ‘woocommerce_ac_send_email_action’ has to run in the background.