Changeset 60697 for trunk/src/wp-includes/general-template.php

Timestamp:

08/31/2025 09:41:54 PM (12 months ago)

Author:

spacedmonkey

Message:

Caching API: Use consistent cache keys for query groups.

Query-based caches are now improved by reusing cache keys. Previously, cache keys for query caches were generated using the last_changed value as part of the key. This meant that whenever last_changed was updated, all the previously cached values for the group became unreachable.

The new approach allows WordPress to replace previously cached results that are known to be stale. The previous approach relied on the object cache backend evicting stale keys which is done at various levels of efficiency.

To address this, the following new helper functions have been introduced:

• wp_cache_get_salted
• wp_cache_set_salted
• wp_cache_get_multiple_salted
• wp_cache_set_multiple_salted

These functions provide a consistent way to get/set query caches. Instead of using the last_changed value as part of the cache key, it is now stored inside the cache value as a "salt". This allows cache keys to be reused, with values updated in place rather than relying on eviction of outdated entries.

Props spacedmonkey, peterwilsoncc, flixos90, sanchothefat, tillkruess, rmccue, mukesh27, adamsilverstein, owi, nickchomey.

File:

• trunk/src/wp-includes/general-template.php (modified) (5 diffs)

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

@@ -2070 +2070 @@
                 $query   = "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date $order $limit";
                 $key     = md5( $query );
-                $key     = "wp_get_archives:$key:$last_changed";
-                $results = wp_cache_get( $key, 'post-queries' );
+                $key     = "wp_get_archives:$key";
+                $results = wp_cache_get_salted( $key, 'post-queries', $last_changed );
                 if ( ! $results ) {
                         $results = $wpdb->get_results( $query );
-                        wp_cache_set( $key, $results, 'post-queries' );
+                        wp_cache_set_salted( $key, $results, 'post-queries', $last_changed );
                 }
                 if ( $results ) {
@@ -2095 +2095 @@
                 $query   = "SELECT YEAR(post_date) AS `year`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date) ORDER BY post_date $order $limit";
                 $key     = md5( $query );
-                $key     = "wp_get_archives:$key:$last_changed";
-                $results = wp_cache_get( $key, 'post-queries' );
+                $key     = "wp_get_archives:$key";
+                $results = wp_cache_get_salted( $key, 'post-queries', $last_changed );
                 if ( ! $results ) {
                         $results = $wpdb->get_results( $query );
-                        wp_cache_set( $key, $results, 'post-queries' );
+                        wp_cache_set_salted( $key, $results, 'post-queries', $last_changed );
                 }
                 if ( $results ) {
@@ -2119 +2119 @@
                 $query   = "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, DAYOFMONTH(post_date) AS `dayofmonth`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date) ORDER BY post_date $order $limit";
                 $key     = md5( $query );
-                $key     = "wp_get_archives:$key:$last_changed";
-                $results = wp_cache_get( $key, 'post-queries' );
+                $key     = "wp_get_archives:$key";
+                $results = wp_cache_get_salted( $key, 'post-queries', $last_changed );
                 if ( ! $results ) {
                         $results = $wpdb->get_results( $query );
-                        wp_cache_set( $key, $results, 'post-queries' );
+                        wp_cache_set_salted( $key, $results, 'post-queries', $last_changed );
                 }
                 if ( $results ) {
@@ -2145 +2145 @@
                 $query   = "SELECT DISTINCT $week AS `week`, YEAR( `post_date` ) AS `yr`, DATE_FORMAT( `post_date`, '%Y-%m-%d' ) AS `yyyymmdd`, count( `ID` ) AS `posts` FROM `$wpdb->posts` $join $where GROUP BY $week, YEAR( `post_date` ) ORDER BY `post_date` $order $limit";
                 $key     = md5( $query );
-                $key     = "wp_get_archives:$key:$last_changed";
-                $results = wp_cache_get( $key, 'post-queries' );
+                $key     = "wp_get_archives:$key";
+                $results = wp_cache_get_salted( $key, 'post-queries', $last_changed );
                 if ( ! $results ) {
                         $results = $wpdb->get_results( $query );
-                        wp_cache_set( $key, $results, 'post-queries' );
+                        wp_cache_set_salted( $key, $results, 'post-queries', $last_changed );
                 }
                 $arc_w_last = '';
@@ -2184 +2184 @@
                 $query   = "SELECT * FROM $wpdb->posts $join $where ORDER BY $orderby $limit";
                 $key     = md5( $query );
-                $key     = "wp_get_archives:$key:$last_changed";
-                $results = wp_cache_get( $key, 'post-queries' );
+                $key     = "wp_get_archives:$key";
+                $results = wp_cache_get_salted( $key, 'post-queries', $last_changed );
                 if ( ! $results ) {
                         $results = $wpdb->get_results( $query );
-                        wp_cache_set( $key, $results, 'post-queries' );
+                        wp_cache_set_salted( $key, $results, 'post-queries', $last_changed );
                 }
                 if ( $results ) {