Skip to:
Content

bbPress.org


Ignore:
Timestamp:
07/05/2012 05:32:33 AM (13 years ago)
Author:
johnjamesjacoby
Message:

Performance:

  • Add 'numeric' to applicable meta-queries to avoid casting as char.
  • Remove meta-queries, and use post_parent where possible.
  • Introduce _bbp_has_replies_where() filter, attached to 'posts_where' which is responsible for adding the lead topic to the results. This avoids having to use a costly meta-query, potentially resulting in full table scans.
  • Audit meta-queries, and tweak where needed.
  • Fixes #1885.
  • Props vibol for investigation.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/plugin/bbp-includes/bbp-core-shortcodes.php

    r4048 r4059  
    377377        }
    378378
    379         // Filter the query
    380         if ( ! bbp_is_single_topic() ) {
    381             add_filter( 'bbp_before_has_replies_parse_args', array( $this, 'display_topic_query' ) );
    382         }
    383 
    384379        // Start output buffer
    385380        $this->start( 'bbp_single_topic' );
     
    749744        $args['show_stickies'] = true;
    750745        $args['order']         = 'DESC';
    751         return $args;
    752     }
    753 
    754     /**
    755      * Filter the query for the topic index
    756      *
    757      * @since bbPress (r3637)
    758      *
    759      * @param array $args
    760      * @return array
    761      */
    762     public function display_topic_query( $args = array() ) {
    763         $args['meta_query'] = array( array(
    764             'key'     => '_bbp_topic_id',
    765             'value'   => bbpress()->current_topic_id,
    766             'compare' => '='
    767         ) );
    768 
    769746        return $args;
    770747    }
Note: See TracChangeset for help on using the changeset viewer.