Changeset 12376

Timestamp:

12/11/2009 11:29:19 PM (16 years ago)

Author:

markjaquith

Message:

Optimize Whoa Cowboy query. Only look back one hour. props mdawaffe. fixes #4366

File:

• trunk/wp-includes/comment.php (modified) (1 diff)

trunk/wp-includes/comment.php

@@ -551 +551 @@
     if ( current_user_can( 'manage_options' ) )
         return; // don't throttle admins
-    if ( $lasttime = $wpdb->get_var( $wpdb->prepare("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_author_IP = %s OR comment_author_email = %s ORDER BY comment_date DESC LIMIT 1", $ip, $email) ) ) {
+    $hour_ago = gmdate( 'Y-m-d H:i:s', time() - 3600 );
+    if ( $lasttime = $wpdb->get_var( $wpdb->prepare( "SELECT `comment_date_gmt` FROM `$wpdb->comments` WHERE `comment_date_gmt` >= %s AND ( `comment_author_IP` = %s OR `comment_author_email` = %s ) ORDER BY `comment_date_gmt` DESC LIMIT 1", $hour_ago, $ip, $email ) ) ) {
         $time_lastcomment = mysql2date('U', $lasttime, false);
         $time_newcomment  = mysql2date('U', $date, false);