[wp-trac] [WordPress Trac] #19901: Speeding up Dashboard and Comment moderation SQL load

[WordPress Trac]

#19901: Speeding up Dashboard and Comment moderation SQL load
-------------------------+--------------------------
 Reporter:  FolioVision  |       Owner:  markjaquith
     Type:  enhancement  |      Status:  accepted
 Priority:  normal       |   Milestone:  3.4
Component:  Performance  |     Version:  3.3.1
 Severity:  critical     |  Resolution:
 Keywords:  needs-patch  |
-------------------------+--------------------------
Changes (by markjaquith):

 * owner:   => markjaquith
 * status:  new => accepted


Comment:

 I validated these results. The large dataset was 4.7 million comments.
 It's much, much faster to query the individual approval statuses. It seems
 that statuses with more members take longer, so inferring the "1" result
 by subtracting the other results from the total is a nice speedup.

 On a small site (50,000 comments), there was still a speedup, going from
 50ms to 10ms. So I think we should do this for every site, not just sites
 with large numbers of comments.

 I'm going ahead with a patch.

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