[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:  Awaiting Review
Component:  Administration  |     Version:  4.3.1
 Severity:  critical        |  Resolution:
 Keywords:                  |     Focuses:  performance
----------------------------+------------------------------
Changes (by cmmmc):

 * version:   => 4.3.1
 * severity:  normal => critical


Comment:

 Hi there,

 I'm afraid I'm not that genius so can't contribute much other than saying
 that this is still an issue in WP 4.3.1.

 Is there a quick and dirty (i.e. temporary) fix to easily adjust this?
 (whether in mysql or by editing a core file)

 We've got 10M+ rows (woocommerce enabled site) and this definitely
 expensive query is crippling the back-end completely...

 The front end seems to be OK, although it's touch and go because of the
 back-end issue.

 I've been looking for a temporary solution and been trying to find out
 where this expensive query sits, but nothing I can find that works (not
 even in the includes/templates.php

 I also already have applied these two solutions:

 {{{
 // Remove Custom Fields box from the Post edit screen.
 function remove_post_custom_fields_now() {

   $post_types = get_post_types( '', 'names' );

   foreach ( $post_types as $post_type ) {
     remove_meta_box( 'postcustom' , $post_type , 'normal' );
   }

 }

 add_action( 'admin_menu' , 'remove_post_custom_fields_now' );
 }}}

 and


 {{{
 //Fix Custom Field slow issue
 function remove_metaboxes() {
      remove_meta_box( 'postcustom', 'page', 'normal', 'orders' );
 }
 add_action('admin_menu', 'remove_metaboxes');
 }}}

 It's getting so bad that I'm really in trouble soon...

 Any temporary fixes or suggestions are much, much appreciated (hopefully
 others can benefit too).

 Thanks, CM

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