Performance concern

Hi Tyler,

we’re using Query Monitor and I just retested a logged-in frontend page load and I can’t reproduce any WP Mail SMTP queries.

Could you please look into the actual queries that your WP site is labeling as WP Mail SMTP and let us know the list of these queries?

Our plugin does not perform any DB queries on frontend page loads. It mainly operates in the admin dashboard or when an email is being sent from your site. We are using the Action Scheduler (AS) library and since we include it in our plugin code, these queries could potentially be marked as WP Mail SMTP. But even AS queries should not fire on each page load…

Please let us know more details about those queries and we can look into what is happening on your website.

Take care!

14 SELECT option_value
FROM wptt_options
WHERE option_name = ‘as_has_wp_comment_logs’
LIMIT 1

get_option()

Plugin: wp-mail-smtp 0 0.0005
18 SELECT option_value
FROM wptt_options
WHERE option_name = ‘wp_mail_smtp’
LIMIT 1

get_option()

Plugin: wp-mail-smtp 1 0.0005
20 SELECT a.action_id
FROM wptt_actionscheduler_actions a
WHERE a.hook=’wp_mail_smtp_summary_report_email’
AND a.status=’in-progress’
ORDER BY scheduled_date_gmt DESC
LIMIT 1

ActionScheduler_DBStore->find_action()

Plugin: wp-mail-smtp 0 0.0018
21 SELECT a.action_id
FROM wptt_actionscheduler_actions a
WHERE a.hook=’wp_mail_smtp_summary_report_email’
AND a.status=’pending’
ORDER BY scheduled_date_gmt ASC
LIMIT 1

ActionScheduler_DBStore->find_action()

Plugin: wp-mail-smtp 1 0.0005
22 SELECT a.*, g.slug AS group
FROM wptt_actionscheduler_actions a
LEFT JOIN wptt_actionscheduler_groups g
ON a.group_id=g.group_id
WHERE a.action_id=413

ActionScheduler_DBStore->fetch_action()

Plugin: wp-mail-smtp 1 0.0006

Hi Tyler,

as you can see all of the above selects are triggered by Action Scheduler library (which is bundled with our plugin). We are using AS to queue and process background tasks (more expensive tasks).

Are these queries present on each page load on your site or did you have to refresh your site a couple of times in order to see those queries?

These queries should not be present all the time, if they are, something is wrong with the AS set up on your site (or WP core cron scheduler). By default AS hooks up to the WP core cron scheduler which by default runs every minute. Did you maybe change that default value somehow?

Take care!

Hi @tylertork,

We haven’t heard from you in about a while, so I’m going to go ahead and mark this ticket resolved.

If you still have questions, though, please feel welcome to continue the conversation.

Thanks!