[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:  closed
 Priority:  normal                   |   Milestone:
Component:  Administration           |     Version:  4.3.1
 Severity:  normal                   |  Resolution:  invalid
 Keywords:  has-patch needs-testing  |     Focuses:  administration,
  needs-unit-tests needs-refresh     |  performance
  close                              |
-------------------------------------+-------------------------------------

Comment (by perlfan):

 Hi there, I also converted my meta_type field type to varchar 191, hoping
 this would reduce also the table size (which did not happen). I have a 1
 GB wp_postmeta table - the size causes problems with backup problems,
 update operations etc. The table is bloated because of my variations which
 is of course the root of the problem which I cannot solve. So I thought
 about converting the meta_value longtext type to mediumtext. In my staging
 environment, postmeta shrank to 400 mb. Did anybody do such thing already?
 Is this recommended or too criticial? Thanks for help. Frank

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