Changeset 43382

Timestamp:

06/26/2018 04:29:33 PM (7 years ago)

Author:

flixos90

Message:

Multisite: Count users in a more performant way when listing sites in the network admin.

Props spacedmonkey.
Fixes #44368.

File:

• trunk/src/wp-admin/includes/class-wp-ms-sites-list-table.php (modified) (1 diff)

trunk/src/wp-admin/includes/class-wp-ms-sites-list-table.php

@@ -407 +407 @@
         $user_count = wp_cache_get( $blog['blog_id'] . '_user_count', 'blog-details' );
         if ( ! $user_count ) {
-            $blog_users = get_users(
-                array(
-                    'blog_id' => $blog['blog_id'],
-                    'fields'  => 'ID',
-                )
-            );
-            $user_count = count( $blog_users );
-            unset( $blog_users );
+            $blog_users = new WP_User_Query( array(
+                'blog_id'     => $blog['blog_id'],
+                'fields'      => 'ID',
+                'number'      => 1,
+                'count_total' => true,
+            ) );
+            $user_count = $blog_users->get_total();
             wp_cache_set( $blog['blog_id'] . '_user_count', $user_count, 'blog-details', 12 * HOUR_IN_SECONDS );
         }