[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 needs-testing  |     Focuses:  performance
-------------------------------------+--------------------------

Comment (by jnylen0):

 In [changeset:"40382"]:
 {{{
 #!CommitTicketReference repository="" revision="40382"
 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.
 }}}

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