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

WordPress Trac noreply at wordpress.org
Tue Jan 10 14:26:06 UTC 2017

#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):


 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

More information about the wp-trac mailing list