[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:  needs-patch   |     Focuses:  performance
--------------------------+-----------------------------
Changes (by pento):

 * keywords:   => needs-patch
 * milestone:   => Future Release


Comment:

 Thanks for the extra information, @rodrigosprimo!

 This seems like a fairly simple use case, and one that's certainly likely
 to become more common once a full custom comment type API is added.

 We should consider an index like this, when that happens. In the mean
 time, I don't mind if plugins add their own index to the table, but it'd
 be nice if you did the following:

 * Prefix the index name with `woo_`, so that it will never clash with a
 Core index name.
 * Keep subscribing to this ticket, so you know when a Core index has
 landed - you can then update your code to stop adding the custom index,
 and to remove the redundant index from exisiting installs (once they've
 updated their Core version, that is).

 @rachelbaker: I don't suppose you have a Trac keyword you're using to
 track custom comment type tickets?

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