Changeset 3919

Timestamp:

09/01/2016 08:47:41 PM (8 years ago)

Author:

jmdodd

Message:

Support Forums: Improve feed performance.

File:

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

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

@@ -16 +16 @@
         // Query simplification.
         add_filter( 'bbp_after_has_topics_parse_args', array( $this, 'has_topics' ) );
+        add_filter( 'bbp_after_has_replies_parse_args', array( $this, 'has_replies' ) );
         add_filter( 'bbp_register_view_no_replies', array( $this, 'no_replies' ) );
     }
@@ -33 +34 @@
      */
     public function has_topics( $r ) {
+        /**
+         * Feeds
+         */
+        if ( is_feed() ) {
+            $r['no_found_rows'] = true;
+            add_filter( 'posts_where', array( $this, 'posts_in_last_month' ) );
+        }
+
         /**
          * Filter queries so they are not sorted by the post meta value of
@@ -70 +79 @@
     }
 
+    public function has_replies( $r ) {
+        if ( is_feed() ) {
+            $r['no_found_rows'] = true;
+            add_filter( 'posts_where', array( $this, 'posts_in_last_month' ) );
+        }
+        return $r;
+    }
+
     public function no_replies( $r ) {
         $r['post_parent__not_in'] = array( Plugin::THEMES_FORUM_ID, Plugin::PLUGINS_FORUM_ID, Plugin::REVIEWS_FORUM_ID );
         return $r;
+    }
+
+    public function posts_in_last_month( $w ) {
+        global $wpdb;
+
+        $bound_id = $this->get_bound_id( '1 MONTH' );
+        $w .= $wpdb->prepare( " AND ( $wpdb->posts.ID >= %d )", $bound_id );
+        return $w;
     }