Changeset 5862

Timestamp:

09/03/2017 10:04:47 AM (7 years ago)

Author:

SergeyBiryukov

Message:

Support Forums: Add caching for user's topics and reviews count queries.

Props ketuchetan for initial patch.
Fixes #2967.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/support-forums/inc/class-users.php (modified) (3 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/support-forums/inc/class-users.php

@@ -31 +31 @@
         add_filter( 'bbp_replies_pagination',          array( $this, 'parse_user_topics_pagination_args' ) );
         add_filter( 'bbp_before_title_parse_args',     array( $this, 'parse_user_topics_title_args' ) );
+
+        // Clear user's topics and reviews count cache.
+        add_action( 'bbp_new_topic',                   array( $this, 'clear_user_topics_count_cache' ), 10, 4 );
     }
 
@@ -284 +287 @@
         }
 
-        $count = (int) $wpdb->get_var( $wpdb->prepare(
-            "SELECT COUNT(*)
-                FROM {$wpdb->posts}
-                WHERE post_type = 'topic'
-                    AND post_status IN ( 'publish', 'closed' )
-                    AND post_parent <> %d
-                    AND post_author = %d",
-            Plugin::REVIEWS_FORUM_ID,
-            $user_id
-        ) );
+        // Check cache.
+        $count = wp_cache_get( $user_id, 'user-topics-count' );
+        if ( false === $count ) {
+            $count = (int) $wpdb->get_var( $wpdb->prepare(
+                "SELECT COUNT(*)
+                    FROM {$wpdb->posts}
+                    WHERE post_type = 'topic'
+                        AND post_status IN ( 'publish', 'closed' )
+                        AND post_parent <> %d
+                        AND post_author = %d",
+                Plugin::REVIEWS_FORUM_ID,
+                $user_id
+            ) );
+            wp_cache_set( $user_id, $count, 'user-topics-count' );
+        }
 
         return $count;
@@ -318 +326 @@
         }
 
-        $count = (int) $wpdb->get_var( $wpdb->prepare(
-            "SELECT COUNT(*)
-                FROM {$wpdb->posts}
-                WHERE post_type = 'topic'
-                    AND post_status IN ( 'publish', 'closed' )
-                    AND post_parent = %d
-                    AND post_author = %d",
-            Plugin::REVIEWS_FORUM_ID,
-            $user_id
-        ) );
+        // Check cache.
+        $count = wp_cache_get( $user_id, 'user-reviews-count' );
+        if ( false === $count ) {
+            $count = (int) $wpdb->get_var( $wpdb->prepare(
+                "SELECT COUNT(*)
+                    FROM {$wpdb->posts}
+                    WHERE post_type = 'topic'
+                        AND post_status IN ( 'publish', 'closed' )
+                        AND post_parent = %d
+                        AND post_author = %d",
+                Plugin::REVIEWS_FORUM_ID,
+                $user_id
+            ) );
+            wp_cache_set( $user_id, $count, 'user-reviews-count' );
+        }
 
         return $count;
     }
 
+    /**
+     * Clear user's topics and reviews count cache.
+     *
+     * @param int   $topic_id       Topic ID.
+     * @param int   $forum_id       Forum ID.
+     * @param array $anonymous_data Anonymous poster data.
+     * @param int   $topic_author   Topic author ID.
+     */
+    public function clear_user_topics_count_cache( $topic_id, $forum_id, $anonymous_data, $topic_author ) {
+        if ( Plugin::REVIEWS_FORUM_ID != $forum_id ) {
+            wp_cache_delete( $topic_author, 'user-topics-count' );
+        } else {
+            wp_cache_delete( $topic_author, 'user-reviews-count' );
+        }
+    }
+
 }