[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 sboisvert):

 Replying to [comment:46 mintindeed]:
 > I think the index is a more sound strategy.

 I'd tend to agree but from some of the reports up top there it's not
 always used efficiently by MySQL and I would rather perfect not be the
 enemy of better :).

 > If that's not enough, then I'd suggest instead of using a transient, set
 a flag.

 Sure, I don't see a big difference either way. My reasoning for the
 transient was that on busy sites that have a object cache it would
 probably be faster than doing a separate db request, unless we make it an
 auto-load option (which I personally try to avoid)

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