[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:  6.0
Component:  Administration                       |     Version:  4.3.1
 Severity:  critical                             |  Resolution:
 Keywords:  has-patch needs-testing needs-unit-  |     Focuses:
  tests                                          |  performance
-------------------------------------------------+-------------------------
Changes (by SergeyBiryukov):

 * milestone:  Future Release => 6.0


Comment:

 Catching up with the latest comments here, the
 [https://wordpress.org/plugins/index-wp-mysql-for-speed/ Index WP MySQL
 For Speed] plugin suggested in comment:86 looks quite impressive, and the
 [https://www.plumislandmedia.net/index-wp-mysql-for-speed/tables_and_keys/
 theory behind it] is also a recommended reading.

 This is also being discussed in the new Performance team repo:
 [https://github.com/WordPress/performance/issues/132 Revisit indexes for
 DB performance]. With enough eyes and testing, I believe it could be one
 of the team's focuses in near future.

 In the meantime, I would like to revisit [attachment:"33885.5.diff"] as
 suggested in comment:61, which should improve performance for those using
 persistent object caching like Memcached or Redis. This could also use
 some testing.

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