[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:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Media         |    Version:  4.7
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 In the ajax-actions.php file there is function called
 wp_ajax_query_attachments. This function is responsible for searching
 images in the media library.

 We see that in Wordpress 4.7, someone added a new filter to this function:

         // Filter query clauses to include filenames.
         if ( isset( $query['s'] ) ) {
                 add_filter( 'posts_clauses',
 '_filter_query_attachment_filenames' );
         }

 This filter is a performance killer and takes forever to output a result
 in large databases. We have tested this with db that has over 500000
 posts.

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