Changeset 59817 for trunk/src/wp-includes/user.php

Timestamp:

02/12/2025 09:48:04 PM (2 months ago)

Author:

spacedmonkey

Message:

Users: Add caching to count_user_posts function

Introduced caching for the count_user_posts function to reduce redundant database queries. This ensures better performance by storing and reusing query results when possible. Additionally, sanitized and sorted the $post_type array to avoid invalid queries.

Props spacedmonkey, peterwilsoncc, mamaduka, flixos90, johnjamesjacoby, swissspidy, dilip2615, johnregan3, wpgurudev, desrosj, milindmore22, Krstarica, dilipom13.
Fixes #39242.

File:

• trunk/src/wp-includes/user.php (modified) (1 diff)

trunk/src/wp-includes/user.php

@@ -605 +605 @@
     global $wpdb;
 
+    $post_type = array_unique( (array) $post_type );
+    sort( $post_type );
+
     $where = get_posts_by_author_sql( $post_type, true, $userid, $public_only );
-
-    $count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts $where" );
+    $query = "SELECT COUNT(*) FROM $wpdb->posts $where";
+
+    $last_changed = wp_cache_get_last_changed( 'posts' );
+    $cache_key    = 'count_user_posts:' . md5( $query ) . ':' . $last_changed;
+    $count        = wp_cache_get( $cache_key, 'post-queries' );
+    if ( false === $count ) {
+        $count = $wpdb->get_var( $query );
+        wp_cache_set( $cache_key, $count, 'post-queries' );
+    }
 
     /**