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

Comment (by ryan):

 Also, a hack I've seen done for sites with millions of comments and high
 comment volume is to just not do the count queries.  Comment counts become
 rather meaningless for such sites.  Maybe worth a throttle or don't care
 switch. Maybe not.

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