Changeset 34217

Timestamp:

09/15/2015 08:52:40 PM (9 years ago)

Author:

boonebgorges

Message:

Omit the ORDER BY clause when updating object term cache.

The ORDER BY clause was forcing filesorts on large tables, and is
unnecessary, since term order doesn't matter when updating the cache.

Props mbrandys, wonderboymusic.
Fixes #28922.

File:

• trunk/src/wp-includes/taxonomy-functions.php (modified) (1 diff)

trunk/src/wp-includes/taxonomy-functions.php

@@ -3275 +3275 @@
         return false;
 
-    $terms = wp_get_object_terms($ids, $taxonomies, array('fields' => 'all_with_object_id'));
+    $terms = wp_get_object_terms( $ids, $taxonomies, array(
+        'fields' => 'all_with_object_id',
+        'orderby' => 'none',
+    ) );
 
     $object_terms = array();