[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:  Future
Component:  Media                                |  Release
 Severity:  normal                               |     Version:  4.1
 Keywords:  dev-feedback reporter-feedback 2nd-  |  Resolution:
  opinion has-patch                              |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------

Comment (by sboisvert):

 > I also like @sboisvert's idea. Though, I'd personally want them to be
 cacheable, not just bypassable—i.e. each query would also need an action
 after the queries execute to cache the results—so the results may be
 supplied back to those new filters.

 The way the filter is setup it needs to be passed a non-false value to
 continue, this value would most likely come from a cache the user has
 setup  (or an external commenting system hypothetically).

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