[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:       
--------------------------+-------------------------------------------------

Comment(by miqrogroove):

 count(ID) adds null-checking, which is not what we want to do in an
 optimization patch.  It's contrary to the schema:

 {{{
 CREATE TABLE $wpdb->posts (
   ID bigint(20) unsigned NOT NULL auto_increment
 }}}

 > that'd be an awesome improvement

 It's an easy one, too.

 Denis, are you willing to mention this bug in one of your blog posts?

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