Changeset 11241

Timestamp:

05/08/2009 06:04:13 PM (15 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;
 }