Title: High MySQL Queries?
Last modified: August 21, 2016

---

# High MySQL Queries?

 *  [jaspud](https://wordpress.org/support/users/jaspud/)
 * (@jaspud)
 * [12 years ago](https://wordpress.org/support/topic/high-mysql-queries/)
 * Hi there,
 * I’ve been running p3 plugin profiler to find what might be slowing down my sites
   and I was getting a mysql queries in the range of 500-800 every time. When I 
   disable email users, it immediately drops to under 80 everytime. Any guess why
   this is or if there is a way to prevent it so I can keep using the plugin?
 * Does the notifications on/off settings have anything to do with this?
 * [https://wordpress.org/plugins/email-users/](https://wordpress.org/plugins/email-users/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Thread Starter [jaspud](https://wordpress.org/support/users/jaspud/)
 * (@jaspud)
 * [12 years ago](https://wordpress.org/support/topic/high-mysql-queries/#post-4830989)
 * I am using email users in conjunction with a website that uses s2member, event
   espresso and wpmandrill. I tested the mysql queries on several sites (have 11
   similar) and the massive drop in queries happened in all of them with deactivation
   of the email users plugin.
 *  Plugin Author [Mike Walsh](https://wordpress.org/support/users/mpwalsh8/)
 * (@mpwalsh8)
 * [12 years ago](https://wordpress.org/support/topic/high-mysql-queries/#post-4831088)
 * Do you see the query being run on every page load? If so, frontend or dashboard?
   The only time the query needs to be run is when composing a message or notification
   or when on the user settings page.
 * If the queries are running frequently something sounds wrong.
 *  Thread Starter [jaspud](https://wordpress.org/support/users/jaspud/)
 * (@jaspud)
 * [12 years ago](https://wordpress.org/support/topic/high-mysql-queries/#post-4831094)
 * Yes, they’re being run always. I have mass message and notification turned to
   ON for every user which we manually turned on.
 * I assumed it would only run when sending a message or grabbing users for a message.
 *  Thread Starter [jaspud](https://wordpress.org/support/users/jaspud/)
 * (@jaspud)
 * [12 years ago](https://wordpress.org/support/topic/high-mysql-queries/#post-4831095)
 * I think if I’m using the profiler correctly, its dashboard side
 *  Plugin Author [Mike Walsh](https://wordpress.org/support/users/mpwalsh8/)
 * (@mpwalsh8)
 * [12 years ago](https://wordpress.org/support/topic/high-mysql-queries/#post-4831254)
 * I took a quick look at this while making a small update for PHP 5.5 today and
   didn’t find anything. I saw the user queries (all calls to get_users()) happen
   when I would expect them to (when sending an email or notification, on the main
   Dashboard). When I visited other Dashboard pages I do not see the query.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘High MySQL Queries?’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/email-users_a0e0cf.svg)
 * [Email Users](https://wordpress.org/plugins/email-users/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/email-users/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/email-users/)
 * [Active Topics](https://wordpress.org/support/plugin/email-users/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/email-users/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/email-users/reviews/)

## Tags

 * [email](https://wordpress.org/support/topic-tag/email/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 5 replies
 * 2 participants
 * Last reply from: [Mike Walsh](https://wordpress.org/support/users/mpwalsh8/)
 * Last activity: [12 years ago](https://wordpress.org/support/topic/high-mysql-queries/#post-4831254)
 * Status: not resolved