[wp-trac] [WordPress Trac] #31071: post_mime_type related queries still slow on larger sites

[WordPress Trac]

#31071: post_mime_type related queries still slow on larger sites
------------------------------+--------------------------
 Reporter:  archon810         |       Owner:  pento
     Type:  defect (bug)      |      Status:  assigned
 Priority:  normal            |   Milestone:  4.3
Component:  Media             |     Version:  4.1
 Severity:  normal            |  Resolution:
 Keywords:  has-patch commit  |     Focuses:  performance
------------------------------+--------------------------

Comment (by pento):

 Because it's a new index, there's no need to put it in `upgrade.php` - we
 just need to modify `schema.php`, bump the `db_version`, and `dbDelta()`
 will take care of it.

 Given the purpose of this query, I'm fine with that performance test.

 I am a little concerned about the report in [comment:1 comment #1], that
 adding this index causes other queries to run slow. @archon810, what
 version of MySQL were you seeing this in? Are you still able to reproduce
 it, without the extra `(post_type,post_date)` index?

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