Changeset 6729

Show
Ignore:
Timestamp:
02/05/08 18:04:17 (8 months ago)
Author:
ryan
Message:

Add key on comment_approved,comment_date to speed up last comment modified queries. fixes #5773

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/wp-admin/includes/schema.php

    r6705 r6729  
    5353  PRIMARY KEY  (comment_ID), 
    5454  KEY comment_approved (comment_approved), 
    55   KEY comment_post_ID (comment_post_ID) 
     55  KEY comment_post_ID (comment_post_ID), 
     56  KEY comment_approved_date (comment_approved,comment_date) 
    5657) $charset_collate; 
    5758CREATE TABLE $wpdb->links ( 

  • trunk/wp-includes/comment.php

    r6726 r6729  
    208208    switch ( strtolower($timezone)) { 
    209209        case 'gmt': 
    210             $lastcommentmodified = $wpdb->get_var("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1"); 
     210            $lastcommentmodified = $wpdb->get_var("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date DESC LIMIT 1"); 
    211211            break; 
    212212        case 'blog': 
    213             $lastcommentmodified = $wpdb->get_var("SELECT comment_date FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1"); 
     213            $lastcommentmodified = $wpdb->get_var("SELECT comment_date FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date DESC LIMIT 1"); 
    214214            break; 
    215215        case 'server': 

  • trunk/wp-includes/version.php

    r6705 r6729  
    1717 * @global int $wp_db_version 
    1818 */ 
    19 $wp_db_version = 6689; 
     19$wp_db_version = 6730; 
    2020 
    2121?>