Changeset 11241

Timestamp:

05/08/2009 06:04:13 PM (17 years ago)

Author:

ryan

Message:

Cache get_adjacent_post() queries for the duration of the page load to avoid running queries multiple times

File:

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

trunk/wp-includes/link-template.php

@@ -869 +869 @@
         global $post, $wpdb;
 
-        if( empty($post) || !is_single() || is_attachment() )
+        if ( empty($post) || !is_single() || is_attachment() )
                 return null;
 
@@ -906 +906 @@
         $sort  = apply_filters( "get_{$adjacent}_post_sort", "ORDER BY p.post_date $order LIMIT 1" );
 
-        return $wpdb->get_row("SELECT p.* FROM $wpdb->posts AS p $join $where $sort");
+        $query = "SELECT p.* FROM $wpdb->posts AS p $join $where $sort";
+        $query_key = 'adjacent_post_' . md5($query);
+        $result = wp_cache_get($query_key, 'counts');
+        if ( false !== $result )
+                return $result;
+
+        $result = $wpdb->get_row("SELECT p.* FROM $wpdb->posts AS p $join $where $sort");
+        wp_cache_set($query_key, $result, 'counts');
+        return $result;
 }