[wp-trac] [WordPress Trac] #11914: "Users" admin list slow to generate on large sites

[WordPress Trac]

#11914: "Users" admin list slow to generate on large sites
--------------------------+-------------------------------------------------
 Reporter:  rowanbeentje  |       Owner:       
     Type:  defect (bug)  |      Status:  new  
 Priority:  normal        |   Milestone:  3.0  
Component:  Optimization  |     Version:  2.9.1
 Severity:  normal        |    Keywords:       
--------------------------+-------------------------------------------------
Changes (by miqrogroove):

  * keywords:  users mysql slow query =>
  * priority:  low => normal
  * severity:  minor => normal
  * milestone:  Future Release => 3.0


Comment:

 Let's get the flow of control refactored for version 3.0 or 3.1.  OP says
 the index would make this 5x-10x faster, but correcting the flow of
 control would make it 20x faster if there are 20 users per page.  Do both,
 and it should be 100x faster.

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