[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