[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:
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  Future Release
Component:  Administration           |     Version:  4.3.1
 Severity:  critical                 |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:  performance
-------------------------------------+-----------------------------

Comment (by jb510):

 I was consistently seeing a 15s query time, ran `ALTER TABLE wp_postmeta
 MODIFY meta_key varchar(191);` on the table and now it's down to 0.3s.

 The wp_post_meta table is about 2m rows.

 TY @tollmanz hoping someone can get this into core soon?

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