[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:
     Type:  enhancement                          |  markjaquith
 Priority:  normal                               |      Status:  accepted
Component:  Comments                             |   Milestone:  Future
 Severity:  major                                |  Release
 Keywords:  needs-testing dev-feedback needs-    |     Version:  3.3
  refresh                                        |  Resolution:
                                                 |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------
Changes (by FolioVision):

 * severity:  normal => major


Comment:

 @markjaquith @nacin

 Has our patch for large comment groups been integrated yet?

 Seems a bit to have isolated a 150x performance and have it fail in the
 face of excuses like this:

 > 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.

 Why should we be hacking and reducing functionality instead of fixing when
 the fix is handed to you on a silver platter?

 or even weaker arguments:

 > This is a nice improvement, but there are way more dangerous queries in
 core related to full-table scans of LONGTEXT columns.

 A nice improvement should be ignored as there are worse queries. Well
 let's start by fixing this one and then fix the other ones too.

 The waffling about a 50% performance hit on the non-default InnoDB
 configuration in the face of a 150x increase on the default MyISAM is also
 embarassing.

 Gentlemen (there are no women on this ticket), 4 years ago we gave Core
 WordPress a 150x improvement and you still four years later can't
 implement it? It looks like Ryan's main role here is to shoot down
 external contributions.

 Is it any wonder you have trouble getting coders not "in the club" to
 contribute to core WordPress?

 Sincerely, Alec Kinnear

--
Ticket URL: <https://core.trac.wordpress.org/ticket/19901#comment:21>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform