How many users in your WordPress database? The only thing Email Users does which takes any time is query the user database data in order to build up the potential recipients. If you have a lot of users and/or have a lot of user meta data, these queries can take a while. The query itself is broken up into chunks so memory isn’t exhausted but the page load itself may take a while.
We have 2500 users. Since these users are a mark of success for our clients and we want that number to grow we would be happy to pay for a more scalable alternative/upgrade. However typically the largest group is approx 500 graduates of the course.
I did some database optimization/autoload reduction/plugin audits and it seems to be working better. Just curious is it necessary to query all the users even though only a subset/group is being requested? I believe you use Select2 for input fields so that shouldn’t be an issue.
We do have approx 90 groups though as we use a group to separate each intake of students to a course. Hopefully that isn’t the issue as this will grow as well.
Finally we host with WPEngine in the hopes it allows us to scale.
We also use Mailgun and the Mailgun for WordPress plugin to send mail. Trying to follow all recommendations to make this system work. Would welcome more tips
-
This reply was modified 8 years, 8 months ago by
info2grow.
While 2500 users is a lot, I wouldn’t think that would cause an issue. I’ve seen sites with close to 10,000 users work ok. In fact, it was a site with ~8000 users which caused the change to the plugin to divide the query into chunks.
I don’t have any experience with Mailgun so can’t offer any suggestions in that area. There is some additional details about the queries which is output in the HTML comments when querying the users.
There is a post on my web site which shows some details along with a beta version that has additional debugging around queries available if you want to try it.
Thanks Mike, still having the issue and WPEngine is blaming it for causing 502 errors when we try to access the Dashboard or Updates in the backend.
Maybe these screenshots might help?
https://p5.zdusercontent.com/attachment/48506/3pWevPNvHcZ8OqcEiQELdHt44?token=eyJhbGciOiJkaXIiLCJlbmMiOiJBMTI4Q0JDLUhTMjU2In0..8Of-Lhy4VlUx6aAaJAdeTw.k6lREmsjLz_w3q-IXrHUr8rL9OQlZkRORNQsJTtkA77ZM_lArbckUZayImxY-smYRCroRJKueOrQ11fxEfD1NwYar3K_jA7ZAn3URlKoZa2-rGifuJKOZBfVVEjctnEJqfNZBmPNrtnrZ4PKDawByLKGrD72DoFN3JDm9oQN9yxByiRAqpzPLfdyLhdIUbqzTs4JXbuc9idDV5NPWEgE9VgeYyIkHqUG9lhfVHj8zYvaAU6iK-9UQd7JzDHI5wFxR3azR2PbpeGhl6_L3tLb7tDLMpD1asGowEi5o1PxQzo.gVUz66Itx39-pCJpkwhMIw
https://p5.zdusercontent.com/attachment/48506/GncYCt7sYFpwQsfjwIm39SmlM?token=eyJhbGciOiJkaXIiLCJlbmMiOiJBMTI4Q0JDLUhTMjU2In0..bqR72qad1q55V_Q7xmJo6Q.Ip3ovA9co9NubFLzP_LSFRzLc7q-hh7CvDo0S86EUOGV9LfXDrJdnNUt6tVp5TmmAt28c4njWhszwvfF0a3f6qlNCicJTLSkm9vYsbJC_Ry4ppkJ9Jx-_fZ787Yw_JODin70quw–gWtWc7-cwUox1kcrf_E5SPChbhoHikLKeuVVQgxYKpQSwKR_tnAG5GOapzN4dcQMcd2KqjoYQ-Sd9Tq3_cx_snQBKrnq1i0k6NT1qMNK_GMt53cudClvFlh7Nkg0uqQ-QRC2zSgQiQ3MoZ5SBhIvih8dDRRICvNQ8k._sRlRR6sRFvoDHBA_umMig
Thanks Mike still getting the errors. WPEngine says they could be the reason we can no longer get into the parts of your backend (they time out).
