[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:                |     Focuses:  performance
--------------------------+------------------------------

Comment (by merts):

 @dd32 Maybe I can suggest another option:

 The size of the table "Post_meta" is not just directly related to
 Wordpress's standard usage. Many plugins such as Advanced Custom Fields
 (highly used by the community) can increase the size of this table
 dramatically. An ordinary user may not be aware of this and he/she is
 probably using a lot of plugins like ACF anyway. As you know, even if you
 remove a plugin you may still find records in the table.

 A non optimized query like the one above can result degradation in
 performance but it is okay because we all make mistakes. However, I
 believe isolating this table in the first place could at least improve the
 performance. Personally, I don't like any plugins to touch post_meta
 table.

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