[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:  joemcgill
     Type:  enhancement                      |      Status:  closed
 Priority:  normal                           |   Milestone:  4.7
Component:  Media                            |     Version:  3.0
 Severity:  normal                           |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests commit  |     Focuses:  administration
---------------------------------------------+-----------------------------

Comment (by sashman13):

 Replying to [comment:31 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.

 This change is proving very problematic on one of our larger client sites.
 They have 886k posts and close to 13 million postmeta entries with well
 over 2 million attachments.  The query generated by this increased their
 media search time from 10 seconds to 25 seconds and worse yet, is locking
 the postmeta table in the MYISAM engine for the entirety of the query due
 to the outer join and tmp table.  The previous search lock was
 insignificant.

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