[wp-trac] [WordPress Trac] #22744: Media search doesn't include file name
WordPress Trac
noreply at wordpress.org
Wed Feb 22 14:33:09 UTC 2017
#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
More information about the wp-trac
mailing list