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

 Well, try it for yourself if you don't believe me :-) - the problem on my
 side is caused by variations as they really bloat the wp_postmeta table. I
 have ca. 40 products, some of them have 400 variations. This leads to
 millions of attribute entries. This problem isalso discussed in many posts
 (e.g. [https://wordpress.stackexchange.com/questions/248207/simple-sql-
 query-on-wp-postmeta-very-slow],
 [https://github.com/woocommerce/woocommerce/issues/15869]). So I don't see
 a solution to increase the site performance (other than by altering the
 tabel structure) as I can't get rid of the variation entries in that
 table. And BTW, it's not guaranteed that switching hosting will help me as
 my I have already good server performance. Frank

 Replying to [comment:109 OllieJones]:
 > It seems unlikely that a conversion of LONGTEXT to MEDIUMTEXT would
 result in a 60% table data size reduction; both are BLOB data types, and
 plus, really long meta_value values are ordinarily quite rare.
 >
 > The same is true of conversion of meta_key from VARCHAR(255) to
 VARCHAR(191), for similar reasons.
 >
 > I wonder whether the contents of that table, or its on-disk structure,
 are somehow anomalous?
 >
 > (I am happy I am not in the budget hosting business, by the way. It must
 be painful to have your most successful customers start having trouble
 because of their success. That's a long way of saying you, @perlfan, may
 need to upgrade hosting.)

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