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

 * keywords:  has-patch commit => has-patch


Comment:

 Thank you for confirming that, @archon810. :-)

 @wonderboymusic: Until we have a solid fix for that query going bad (I'd
 prefer a query rewrite over index tweaks, so that we're not making too
 many index changes), let's hold off on this new index.

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