WordPress.org

Make WordPress Core

Changeset 8813


Ignore:
Timestamp:
09/05/2008 03:43:26 PM (10 years ago)
Author:
ryan
Message:

Lose USE INDEX on comment_date_gmt. It didn't help performance very much and some people are missing the comment_date_gmt index. see #7664

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-includes/comment.php

    r8720 r8813  
    218218        $post_where = '';
    219219
    220     return $wpdb->get_results( "SELECT * FROM $wpdb->comments USE INDEX (comment_date_gmt) WHERE $post_where $approved ORDER BY $orderby $order $number" );
     220    return $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE $post_where $approved ORDER BY $orderby $order $number" );
    221221}
    222222
Note: See TracChangeset for help on using the changeset viewer.