[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:  4.7.4
Component:  Media                         |     Version:  4.1
 Severity:  normal                        |  Resolution:
 Keywords:  has-patch commit fixed-major  |     Focuses:  performance
------------------------------------------+--------------------------

Comment (by swissspidy):

 In [changeset:"40425"]:
 {{{
 #!CommitTicketReference repository="" revision="40425"
 Media: Add filters to allow overriding slow media queries.

 There are a couple of queries that do a full table scan of attachment
 posts to support features of the media library. Pending a more complete
 solution, allow overriding these queries via filters.

 Props sboisvert, jnylen0.
 See #31071.

 Merges [40382] and [40421] to the 4.7 branch.
 }}}

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