[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:  assigned
 Priority:  normal          |   Milestone:  4.3
Component:  Administration  |     Version:  3.5
 Severity:  normal          |  Resolution:
 Keywords:  has-patch       |     Focuses:  performance
----------------------------+--------------------------

Comment (by dd32):

 Replying to [comment:16 chriscct7]:
 > @pento, the "range" one on your test, how does that perform when the
 meta starts with `_Á` or `_ß` as suggested in comment:13?

 I feel like this is a edgecase that we don't necessarily need to optimize
 for heavily. The further regexp/having clauses would filter out those, and
 they're certainly going to be less common.

 The other option is that it's written as {{{meta_key NOT BETWEEN '_' AND
 '`'}}} which should filter out all which start with `_` I think - but i'm
 not sure what performance implications that would have ({{{`}}} is the
 next character up from `_`)

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