[wp-trac] [WordPress Trac] #52360: speed up update_meta_cache with easy fix
WordPress Trac
noreply at wordpress.org
Mon Jan 25 14:02:58 UTC 2021
#52360: speed up update_meta_cache with easy fix
-----------------------------------+-----------------------------
Reporter: vladislavdavarashvili | Owner: (none)
Type: enhancement | Status: new
Priority: normal | Milestone: Awaiting Review
Component: General | Version:
Severity: normal | Keywords:
Focuses: performance |
-----------------------------------+-----------------------------
wp-includes/meta.php:1061
{{{#!php
<?php
$meta_list = $wpdb->get_results( "SELECT $column, meta_key, meta_value
FROM $table WHERE $column IN ($id_list) ORDER BY $id_column ASC", ARRAY_A
);
}}}
in this request should avoid "ORDER BY $id_column ASC" to speed up this
query (at least 3 times faster)
--
Ticket URL: <https://core.trac.wordpress.org/ticket/52360>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform
More information about the wp-trac
mailing list