Changeset 8813

Show
Ignore:
Timestamp:
09/05/08 15:43:26 (3 months 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

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • 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