WordPress.org

Make WordPress Core

Changeset 8813


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