[wp-trac] [WordPress Trac] #39358: Media search speed has been dramatically reduced

[WordPress Trac]

#39358: Media search speed has been dramatically reduced
--------------------------+------------------------------
 Reporter:  merts         |       Owner:  joemcgill
     Type:  defect (bug)  |      Status:  reviewing
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Media         |     Version:  4.7
 Severity:  normal        |  Resolution:
 Keywords:  2nd-opinion   |     Focuses:
--------------------------+------------------------------

Comment (by merts):

 @joemcgill Reducing the amount of queries can be effective but the
 underlying problem is the resulting sql produced by this function. If you
 dump the sql into to error_log, you will see that it joins two tables
 (which can be quite large in our case) with bunch of "or" statements.
 These new "or" statements come from the filter I wrote above.

 Please consider the fact that the previous Wordpress was finishing ajax
 search pretty fast in our db even though we could keep typing in the
 search bar.

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