[wp-trac] [WordPress Trac] #31072: Slow comment-related query slowing down Dashboard

[WordPress Trac]

#31072: Slow comment-related query slowing down Dashboard
--------------------------+-----------------------------
 Reporter:  archon810     |       Owner:
     Type:  defect (bug)  |      Status:  reopened
 Priority:  normal        |   Milestone:  Future Release
Component:  Comments      |     Version:  4.1
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |     Focuses:  performance
--------------------------+-----------------------------
Changes (by rodrigosprimo):

 * keywords:  needs-patch => has-patch


Comment:

 The patch above is my first patch changing WordPress database structure so
 I'm probably missing some parts. I was specially unsure about which
 db_version number to use when checking if the code to add the new index
 should run or not. I used the last SVN revision.

 I noticed that previous indexes that were created are first dropping the
 index so I followed the same pattern. Is this to make sure the query
 doesn't generate an error in case the index already exist in the database?

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