[wp-trac] [WordPress Trac] #31071: media / post_mime_type related queries are very slow on larger sites

[WordPress Trac]

#31071: media / post_mime_type related queries are very slow on larger sites
-------------------------------------------------+-------------------------
 Reporter:  archon810                            |       Owner:  pento
     Type:  defect (bug)                         |      Status:  assigned
 Priority:  normal                               |   Milestone:  Future
Component:  Media                                |  Release
 Severity:  normal                               |     Version:  4.1
 Keywords:  dev-feedback reporter-feedback 2nd-  |  Resolution:
  opinion has-patch                              |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------

Comment (by archon810):

 Replying to [comment:42 jamesmehorter]:
 > @archon810 Interesting! Are you then suggesting that we should include a
 fix for that months/year query regardless? Just in case someone's setup
 somehow triggers the new index to be used incorrectly—even if we can't
 reproduce it now?
 >
 > Anyone else have thoughts on this?

 Unfortunately, it's tough for me to make that call as I'm not sure if it
 happens again for anyone. It could be a gamble to see if you start getting
 reports about it, or forcing a certain index or ignoring a certain other
 one could be an option.

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