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

WordPress Trac noreply at wordpress.org
Mon May 2 12:53:27 UTC 2022

#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,

 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

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

More information about the wp-trac mailing list