[wp-trac] [WordPress Trac] #22744: Media search doesn't include file name

[WordPress Trac]

#22744: Media search doesn't include file name
-------------------------------------------------+-------------------------
 Reporter:  johnbillion                          |       Owner:
     Type:  enhancement                          |  wonderboymusic
 Priority:  normal                               |      Status:  reviewing
Component:  Media                                |   Milestone:  4.7
 Severity:  normal                               |     Version:  3.0
 Keywords:  has-patch needs-testing has-unit-    |  Resolution:
  tests                                          |     Focuses:
                                                 |  administration
-------------------------------------------------+-------------------------

Comment (by joemcgill):

 Some preliminary testing on a site with ~14k attachments and ~18k posts,
 this change increased the main query time from 60.7ms to 187.6ms, which
 may be acceptable since this is only applied in an admin context, but
 testing on installs with a larger number of posts/attachments would be
 appreciated.

 For the sake of testing, [attachment:22744.7.diff] uses a `DISTINCT` query
 instead of `GROUP BY`, which (as I expected) didn't have any measurable
 performance improvement in my tests but may be worth considering.

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