Changeset 9511

Timestamp:

11/04/2008 04:44:55 PM (18 years ago)

Author:

ryan

Message:

Add caching to get_comments(). see #8057

File:

• trunk/wp-includes/comment.php (modified) (2 diffs)

trunk/wp-includes/comment.php

@@ -183 +183 @@
         $defaults = array('status' => '', 'orderby' => 'comment_date_gmt', 'order' => 'DESC', 'number' => '', 'offset' => '', 'post_id' => 0);
 
-        $r = wp_parse_args( $args, $defaults );
-        extract( $r, EXTR_SKIP );
+        $args = wp_parse_args( $args, $defaults );
+        extract( $args, EXTR_SKIP );
+
+        // $args can be whatever, only use the args defined in defaults to compute the key
+        $key = md5( serialize( compact(array_keys($defaults)) )  );
+        $last_changed = wp_cache_get('last_changed', 'comment');
+        if ( !$last_changed ) {
+                $last_changed = time();
+                wp_cache_set('last_changed', $last_changed, 'comment');
+        }
+        $cache_key = "get_comments:$key:$last_changed";
+
+        if ( $cache = wp_cache_get( $cache_key, 'comment' ) ) {
+                return $cache;
+        }
 
         $post_id = absint($post_id);
@@ -219 +232 @@
                 $post_where = '';
 
-        return $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE $post_where $approved ORDER BY $orderby $order $number" );
+        $comments = $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE $post_where $approved ORDER BY $orderby $order $number" );
+        wp_cache_add( $cache_key, $comments, 'comment' );
+
+        return $comments;
 }