[wp-trac] [WordPress Trac] #33885: meta_form performs a potentially expensive query

[WordPress Trac]

#33885: meta_form performs a potentially expensive query
-------------------------------------+-------------------------------------
 Reporter:  jorbin                   |       Owner:  (none)
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  Future Release
Component:  Administration           |     Version:  4.3.1
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:  administration,
  needs-unit-tests needs-refresh     |  performance
  close                              |
-------------------------------------+-------------------------------------

Comment (by OllieJones):

 In the meantime (until the Future Release), for people who have
 performance problems with this query, may I, in shameless self-promotion,
 suggest:

 1. If necessary and possible, upgrade MySQL to, at a minimum, 5.7.

 2. Use the https://wordpress.org/plugins/index-wp-mysql-for-speed/ plugin
 to set up more efficient indexes on the postmeta and other tables.

 Doing these things should mitigate this problem without changes to core.

 Why? Please see my earlier response to this tix at
 https://core.trac.wordpress.org/ticket/33885#comment:86

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