Looping through all users on admin! | ww.wp.xz.cn

Resolved Matt Pramschufer
(@mattpramschufer)

11 years, 5 months ago

So recently our admin was very very slow, after some debugging, we noticed that our admin pages were generating about 50,000 queries on each page load. Come to find out WP User Avatar decides to loop through every member and grab user meta.

SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (5219) ORDER BY umeta_id ASC

So multiply that by as many users as you have and it will cripple the admin.

https://ww.wp.xz.cn/plugins/wp-user-avatar/

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

Flipper Code – WordPress Development Company
(@flippercode)

11 years, 5 months ago

Hello,

This is only happening in the cron job. not on the regular backend or frontend pages. So I’m assuming that you have thousands of users in the system and cron job is not working perfectly for you. right?

Thanks
Thread Starter Matt Pramschufer
(@mattpramschufer)

11 years, 5 months ago
No this is not only done on a cron job, this is EVERY page of the admin. I went and commented out
```
// Remove usermeta fields
        $users = get_users();
        foreach($users as $user) {
              delete_user_meta($user->ID, 'wpua_has_gravatar');
        }
```
on your
public function wpua_options() {

That corrected the issue
Flipper Code – WordPress Development Company
(@flippercode)

11 years, 5 months ago

Hello Matt,

Thank you so much to pointing out this. We have updated the plugin and please use that.

Thanks

Thread Starter Matt Pramschufer
(@mattpramschufer)

11 years, 5 months ago

No problem.

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

The topic ‘Looping through all users on admin!’ is closed to new replies.

4 replies
2 participants
Last reply from: Matt Pramschufer
Last activity: 11 years, 5 months ago
Status: resolved