Changeset 13647

Timestamp:

03/10/2010 06:37:03 PM (15 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 );