Changeset 55085 for trunk/src/wp-includes/link-template.php

Timestamp:

01/18/2023 11:18:36 AM (3 years ago)

Author:

spacedmonkey

Message:

Posts, Post Types: Use persistent caching in get_adjacent_post function.

The function get_adjacent_post cached the results of database query in the cache group counts. This is a none persistent group and meant cache would not persist on the next request. Change cache to save to the posts cache group. Cache invalidation is done by using get last changed value of the posts and terms group as a salt for the cache key.

Props spacedmonkey, peterwilsoncc, johnbillion, boonebgorges, mukesh27, dd32.
Fixes #41131.

File:

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

trunk/src/wp-includes/link-template.php

@@ -1977 +1977 @@
     $sort = apply_filters( "get_{$adjacent}_post_sort", "ORDER BY p.post_date $order LIMIT 1", $post, $order );
 
-    $query     = "SELECT p.ID FROM $wpdb->posts AS p $join $where $sort";
-    $query_key = 'adjacent_post_' . md5( $query );
-    $result    = wp_cache_get( $query_key, 'counts' );
+    $query        = "SELECT p.ID FROM $wpdb->posts AS p $join $where $sort";
+    $key          = md5( $query );
+    $last_changed = wp_cache_get_last_changed( 'posts' );
+    if ( $in_same_term || ! empty( $excluded_terms ) ) {
+        $last_changed .= wp_cache_get_last_changed( 'terms' );
+    }
+    $cache_key = "adjacent_post:$key:$last_changed";
+
+    $result = wp_cache_get( $cache_key, 'posts' );
     if ( false !== $result ) {
         if ( $result ) {
@@ -1992 +1998 @@
     }
 
-    wp_cache_set( $query_key, $result, 'counts' );
+    wp_cache_set( $cache_key, $result, 'posts' );
 
     if ( $result ) {