Changeset 5862

Timestamp:

09/03/2017 10:04:47 AM (9 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' );
+                }
+        }
+
 }