[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:  high          |   Milestone:  3.0                    
Component:  Optimization  |     Version:  2.9.1                  
 Severity:  critical      |    Keywords:  has-patch needs-testing
--------------------------+-------------------------------------------------

Comment(by miqrogroove):

 A few notes on this:

 The schema patch is still in the works.

 There is a leftover array initialization that can be dropped from
 users.php.

 I still have some uncertainty about the new WHERE conditions for post
 counting.  I want to keep it simple, but we might need a new function
 similar to posts_cap_sql().  It would eliminates code duplication but also
 needs to make sense for these queries.

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