This should not break pagination:
add_filter('pre_get_posts', 'optimized_get_posts', 100);
function optimized_get_posts() {
global $wp_query, $wpdb;
$wp_query->query_vars['no_found_rows'] = 1;
$wp_query->found_posts = $wpdb->get_var( "SELECT COUNT(*) FROM wp_posts WHERE 1=1 AND wp_posts.post_type="post" AND (wp_posts.post_status="publish" OR wp_posts.post_status="private")" );
$wp_query->found_posts = apply_filters_ref_array( 'found_posts', array( $wp_query->found_posts, &$wp_query ) );
if($wp_query->query_vars['posts_per_page'] <= 0) {
$wp_query->max_num_pages = 0;
} else {
$wp_query->max_num_pages = ceil($wp_query->found_posts / $wp_query->query_vars['posts_per_page']);
}
return $wp_query;
}
Related Posts:
- WordPress Custom Query
- get_post_meta causes database queries
- Custom MySQL Query with logic
- How to Get All Posts with any post status?
- posts_per_page no limit
- Is this Solution for Caches vs Cookies Going to Get Me in Trouble?
- How can i get count from query post
- query_post by title?
- Why query_posts() isn’t marked as deprecated?
- Alternative to query_posts for main loop? [duplicate]
- how to query posts by category and tag?
- Using WP_Query to Query Multiple Categories with Limited Posts Per Category?
- Order by meta value or date?
- How do I query by post format in WordPress 3.1
- Display posts of the last 7 days
- Is there a way to exclude the content from the post variable to save on RAM usage?
- Filtering posts by post meta data
- Pros and Cons for high “expire time” on wp-super-cache or w3-total-cache? [closed]
- How to query_posts using meta_query to orderby meta_key AND have a secondary sort by date?
- Query posts by custom taxonomy ID
- Display/query post formats
- How to query post by user role?
- How to return results of a get_posts() in explicitly defined order
- Disable WordPress cache programmatically on a request [closed]
- Help to condense/optimize some working code
- How to set posts per page using WP_Query()
- query_posts exclude a meta key
- How do I create a random post that will last for a day
- Ensuring sticky posts are retrieved first (without using two queries)?
- Determine if more posts are available than was asked for in `query_posts()`?
- Get posts by menu ID
- Modify main WordPress loop with a parse_query filter
- query_posts() in function makes global $wp_query out of sync?
- Limiting query_posts to 1, regardless of sticky post?
- How to make “sticky” pages (and query by them)
- Query posts: how to exclude results if post is in multiple categories
- query_posts ->using meta_compare / where meta value is smaller or greater or equals
- Problem with ‘post__not_in’
- How to order posts by descending comment count on taxonomy page?
- Sort posts alphabetically by custom field value, insert divider between different letters
- Is it better practice to use query_posts, WP_Query, or get_posts to create various custom loops within a Page?
- WP 5.8 “Query Loop” block: where to place custom query?
- Sort X categories by last update and show image
- Custom Post Type “Event”: chronological list of recurring events
- using post__in allow duplicate post id
- Pagination on archive.php page
- mysql custom wp query
- My WordPress site always displays a cached version of its homepage
- Best way to load page content in Fancybox popup?
- How should I intercept the main query and inject custom join / order by / group by criteria
- advice on creating a ‘related posts’ query like the one used on stackexchange
- order post my meta value m/d/y format with year as included value
- Order by meta value, pro first, then free
- Having trouble generating pagination links on custom query
- How to create an attachments archive with working pagination?
- _wp_page_template to dynamically use template
- Using dynamic conditions in ‘posts_where’ filter
- Help altering a query to exclude all but standard post format
- List users with the most total posts view
- Schedule Sticky Posts
- Use union/intersection query_posts variables in uri request parameter form?
- query_posts doesn’t order by title
- How to limit search to first letter of title?
- query_posts and pagination, still stuck after much research
- Query posts by taxonomy term name
- Sorting problem with ‘query_posts’ funcion in wordpress. Sort by custom field not working
- Total Count of Posts NOT in Selected Categories?
- Custom query with query_posts doesn’t show post without certain meta_key
- how could I get the pagination as I want to when query posts using get_posts function
- Counter code for paginated category pages in wordpress
- Post Title displaying but not in the wrapped HTML I need
- Author List page: Exclude based on last post date
- WordPress Search Filter Only for Page with Child of Child of Child of Child of Child
- Replace query_posts with pre_get_posts
- How to sort by meta value?
- query_posts sort in multiple directions
- Filter query_posts by tag slug on “Tag Archive” page (when tag is 2 or more words)
- pagination in author.php template returns 404 error
- Problem with single-page for my custom post
- How to ensure that is_search() return false after query_posts
- Warning: urlencode() expects parameter 1 to be string, array given in and not getting the preffered output
- How to modify the query to exclude posts by slug?
- wp-super-cache exclude file from caching
- query recent posts from several categories
- Inserting Post Using wp_insert_post. How to Fill Yoast Plugin SEO Fields
- Show Posts From Same Category OR Same Tag
- Post count per (day/month/year) since blog began
- Example Query Posts Showing the Latest Post with the Featured Image
- Dynamically excluding current page id
- Why is that gdsr_sort=thumbs (GD start rating plugin) only works with query_posts and not with WP_Query?
- How do i paginate query_posts with numeric pagination?
- How can I free up the memory used by update_post_meta?
- Query_posts $query_string
- What is difference between ‘Page Cache’ and ‘Object Cache’ in WordPress?
- How to make the list of post and load on same page with sub-pages [closed]
- Using database meta_values to calculate new post order using pre_get_posts or a ‘request’ hook
- exclude ids through post__not_in
- How to order posts by slug using query_posts/ Wp_query
- How to get 4 Posts after the 5 most recent ones
- Query 1 taxonomy term, exclude another