[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 fixed-major  |     Focuses:  performance
-----------------------------------+--------------------------

Comment (by joemcgill):

 Replying to [comment:56 adamsilverstein]:
 > @sboisvert
 >
 > > Perhaps then we can remove them completely?
 >
 > I like that suggestion!
 >
 > When I go to the media library, I'd like to see a 'Create Video
 Playlist' link that helps me discover that I _can_ create a video
 playlist. If I click on this link and haven't uploaded any videos, it
 would be especially helpful if the 'No items found' message was more
 specific: "Upload some videos to create a video playlist".

 I tend to agree with this. It seems like a bad idea to run extra queries
 just for the purpose of showing some UI here. Additionally, I like the
 idea of showing the UI elements even when there aren't any media items for
 discoverability as @adamsilverstein suggests.

 As we discussed in today's
 [https://wordpress.slack.com/archives/C02SX62S6/p1491501674477527 Media
 meeting], the filters are probably still useful for anyone who wants to
 hide these elements but the names should be less generic. We mentioned
 something like `media_library_show_(audio|video)_playlists`.

 Adding the filters for 4.7.4 is probably fine, but removing queries
 entirely should probably soak in Trunk a bit longer.

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