[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
------------------------------------------+--------------------------

Comment (by oqudoos786):

 Resolution set to fixed
 Status changed from assigned to closed
 In 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.
 http://bambozled.ml
 http://trochlear.ml
 http://perspicyacity.ml
 http://realismy.ml
 http://poppysymic.ml
 http://hagiolatry.ml
 http://foofraw.ml
 http://biggionmyosis.ml
 http://juneyfutz.ml
 http://witlingy.ml
 http://whatshis.ml
 http://trapzoid.ml
 http://plumbago.ml
 http://parhelion.ml
 http://hijinks.ml
 http://genesic.ml
 http://tampion.ml
 http://anovnudnik.ml
 http://ulotrichus.ml
 http://cebocephalic.ml
 http://phautvenery.ml
 http://haberdashry.ml
 http://razzamatazz.ml
 http://abecedaran.ml
 http://cruciatgauss.ml
 http://sussurous.ml
 http://syndyasmian.ml
 http://flankehr.ml
 http://monier.ml
 http://numquid.ml
 http://isoglossal.ml
 http://mainour.ml
 http://chrysarobyaws.ml
 http://hobledethoy.ml
 http://hippocapus.ml
 http://pogonorophy.ml
 http://lessenfizgig.ml
 http://viridigenous.ml
 http://mrmadfacbotchy.ml
 http://laterad.ml
 http://desperuado.ml
 http://gerund.ml
 http://technoracy.ml
 http://awkwyard.ml
 http://tomaley.ml
 http://crapulnce.ml
 http://valetia.ml
 http://urbicolous.ml
 http://occput.ml
 http://gallivaynt.ml
 http://distichous.ml
 http://cartomacy.ml
 http://skietrt.ml
 http://wonky.ml
 http://elinguate.ml
 http://lambrequin.ml
 http://dummkop.ml
 http://orguous.ml
 http://lochlet.ml
 http://siamese.ml
 http://godwottery.ml
 http://whereuntil.ml
 http://donarytedw.ml
 http://cercussuccus.ml
 http://crudivorel.ml
 http://wutheing.ml
 http://chaseknummet.ml
 http://crinigerous.ml
 http://bibliopoly.ml
 http://slyorcaweasel.ml
 http://hotbted.ml
 http://endophagy.ml
 http://partypriescuckoo.ml
 http://caryatid.ml
 http://mainprise.ml
 http://jubile.ml
 http://razzmatzz.ml
 http://catawampus.ml
 http://torsive.ml
 http://cowabtunga.ml

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