Changeset 13647

Timestamp:

03/10/2010 06:37:03 PM (17 years ago)

Author:

ryan

Message:

Add no_found_rows argument to WP_Query::get_posts() to allow forcibly defeating SQL_CALC_FOUND_ROWS. Use no_found_rows for the query in get_boundary_post(). fixes #12557

Location:

trunk/wp-includes

Files:

• link-template.php (modified) (1 diff)
• query.php (modified) (3 diffs)

trunk/wp-includes/link-template.php

@@ -1159 +1159 @@
         $order = $start ? 'ASC' : 'DESC';
 
-        return get_posts( array('numberposts' => 1, 'order' => $order, 'orderby' => 'ID', 'category' => $categories) );
+        return get_posts( array('numberposts' => 1, 'no_found_rows' => true, 'order' => $order, 'orderby' => 'ID', 'category' => $categories) );
 }
 

trunk/wp-includes/query.php

@@ -1673 +1673 @@
                 }
 
+                // If true, forcibly turns off SQL_CALC_FOUND_ROWS even when limits are present.
+                if ( isset($q['no_found_rows']) )
+                        $q['no_found_rows'] = (bool) $q['no_found_rows'];
+                else
+                        $q['no_found_rows'] = false;
+
                 // If a month is specified in the querystring, load that month
                 if ( $q['m'] ) {
@@ -2332 +2338 @@
                         $orderby = 'ORDER BY ' . $orderby;
                 $found_rows = '';
-                if ( !empty($limits) )
+                if ( !$q['no_found_rows'] && !empty($limits) )
                         $found_rows = 'SQL_CALC_FOUND_ROWS';
 
@@ -2357 +2363 @@
                 }
 
-                if ( !empty($limits) ) {
+                if ( !$q['no_found_rows'] && !empty($limits) ) {
                         $found_posts_query = apply_filters( 'found_posts_query', 'SELECT FOUND_ROWS()' );
                         $this->found_posts = $wpdb->get_var( $found_posts_query );