Saul Diaz

The problem with slow query SELECT SQL_CALC_FOUND_ROWS because it had resolved modifying wp-includes/query.php, the WordPress 3.3.1 core, when we updated to version 3.4.1 we noticed that in wp-admin to posts not visualized paging. To solve the problem using the solution proposed phkcorp2005, without modifying the core WordPress 3.4.1 but still had the problem of not displaying the pagination in the wp-admin.

To solve the problem using:

function no_rows_found_function($query) {
	if (!is_admin()) {
		$query->set( 'no_found_rows', true );
	}
}
add_action('pre_get_posts','no_rows_found_function');