[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:  jnylen0
     Type:  defect (bug)                  |      Status:  closed
 Priority:  normal                        |   Milestone:  4.7.4
Component:  Media                         |     Version:  4.1
 Severity:  normal                        |  Resolution:  fixed
 Keywords:  has-patch commit fixed-major  |     Focuses:  performance
------------------------------------------+--------------------------
Changes (by jnylen0):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"40430"]:
 {{{
 #!CommitTicketReference repository="" revision="40430"
 Media: Default to always showing the "Create Audio/Video Playlist"
 buttons.

 This avoids a couple of expensive queries that attempt to determine
 whether the media library contains any audio or video items, and also
 makes the UI for creating playlists more discoverable.

 [40382] and [40421] added filters to allow overriding this behavior; this
 commit changes the default value of the filters to always show these UI
 buttons and never run the expensive queries.  The old behavior can still
 be restored using the filters if desired.

 Props sboisvert, adamsilverstein, joemcgill, jnylen0.
 Fixes #31071.
 }}}

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