[wp-trac] [WordPress Trac] #24498: Improving performance of meta_form()

[WordPress Trac]

#24498: Improving performance of meta_form()
----------------------------+--------------------------
 Reporter:  lumaraf         |       Owner:  pento
     Type:  enhancement     |      Status:  closed
 Priority:  normal          |   Milestone:  4.3
Component:  Administration  |     Version:  3.5
 Severity:  normal          |  Resolution:  fixed
 Keywords:  has-patch       |     Focuses:  performance
----------------------------+--------------------------

Comment (by jorbin):

 We should likely spin this off into it's own ticket. That said, I added an
 additional test case based off tollmanz's github and travis setup (Awesome
 work right there. Thank You) which  sets the innodb_large_prefix option to
 on. This increases the limit beyond 767 byte limit.



 {{{
             | utf8        | utf8mb4      | utf8 meta_key | with option
 utf8 | with option mb4 |
 |-------------|--------------|---------------|------------------|-----------------|
 4.1.x query | 0.00037275s | 39.45441000s | 0.00044975s   | 0.00030775s
 | 17.67479500s    |
 4.3.x query | 0.00047425s | 22.14528975s | 0.00051775s   | 0.00052575s
 | 20.47027650s    |
 }}}

 The options doesn't reduce the query down to the pre utf8mb4 levels.

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