[wp-trac] [WordPress Trac] #11726: wp-admin/users.php crashes on sites with large number of subscribers

[WordPress Trac]

#11726: wp-admin/users.php crashes on sites with large number of subscribers
--------------------------+-------------------------------------------------
 Reporter:  prettyboymp   |       Owner:                         
     Type:  defect (bug)  |      Status:  new                    
 Priority:  normal        |   Milestone:  Unassigned             
Component:  General       |     Version:  2.9.1                  
 Severity:  major         |    Keywords:  has-patch needs-testing
--------------------------+-------------------------------------------------

Comment(by miqrogroove):

 Just to update things here:

 I've been approved to re-factor the entire users.php script under #11914.
 I will not be using the patch provided by prettyboymp because there is an
 opportunity here to address the strategy for role counting at a more
 fundamental level, even without schema changes.

 I do not intend to post a separate patch for this ticket.  I have the
 users.php file pulled all apart and it's full of debug stubs and personal
 commentary.  I can only assure you that the patch for get_users_of_blog()
 eliminates a table join and also reduces the size and data type of the
 query result set.

 The schema is prohibitively non-optimal for 10^6 users per blog, but the
 script re-factor will at least give you some room to grow.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/11726#comment:7>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software