[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
----------------------------+--------------------------
Changes (by pento):

 * owner:   => pento
 * status:  new => assigned
 * milestone:  Awaiting Review => 4.3


Comment:

 [attachment:24498-test.php] is a performance test I ran on these queries,
 the results are attached as CSVs.

 For a quick explanation of the variables:

 `$connections` - I originally planned on running these tests on multiple
 versions of MySQL, but decided that it wasn't really necessary, as these
 are fairly simple queries.
 `$engines` - obvious.
 `$row_counts` - how many rows to insert into the test table.
 `$percent_underscores` - the percentage of rows to have starting with a
 `_`, which affects the comparison part of the query.
 `$unique_keys_count` - the number of unique keys to insert into the table.
 This affects the index cardinality.

 Summary: The original query is clearly slower, but there's very little
 difference between the two proposed queries, with the query in
 [attachment:24498.patch] being slight quicker in most circumstances.

 Unless anyone can show consistent data that one or the other is
 significantly quicker, I'm happy for [attachment:24498.patch] to go into
 4.3.

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