[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 robscott):

 Hey,

 Just posting back here because I refer often to this link (I just sent
 someone here) to add 2 cents. On most managed WP hosts, when the meta
 table is somewhat large (WARNING non specific language!), this can cause a
 big speed increase. This is most often (for me) on quite big WooCommerce
 installations. It almost always speeds up admin and uncached (logged in
 user) pageload times significantly.

 So 8s down to 1.5s loading time on admin load.

 This is on real live sites in the wild! Usually hosted on a dedicated
 managed WP host of one flavour or another.

 I check for the existence of > 190 char meta, then, if that's not there, I
 then run the query:

 `ALTER TABLE wp_postmeta MODIFY meta_key varchar(191);`

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