Query causing load because of SQL_CALC_FOUND_ROWS post counting?

WordPress uses this feature of MySQL to get a total count of posts when you are only retrieving limited amount (100 posts total, but only 10 posts per page).

From quick look at source there is no_found_rows query argument that can disable it. That will wreck pagination and should only be used with specific queries that don’t need counting (for example get_posts() uses it by default).

You probably need to look into performance of your database overall (if you are running something crazy large) or if there are issues with configuration (if you are running something small enough to not possibly cause issues with resources).

Related Posts:

  1. Pagination with custom SQL query
  2. duplicated posts when using pagination
  3. Custom query (author is post_author or meta co_author) with Pagenavi pagination
  4. Pagination when using wp_query?
  5. How to print the excuted sql right after its execution
  6. How can i retrieve default post per page value? from settings->reading. And total number of posts?
  7. Find out total number of pages in global query on archive page?
  8. Post_count only shows the number of results per page
  9. Multiple WP_Query loops with Pagination
  10. Return only Count from a wp_query request?
  11. WordPress Pagination Not Working – Always Showing First Pages Content
  12. get_query_var function not working at all
  13. get_query_var( ‘paged’ ) not working outside of homepage
  14. Pagination on a WP_query not showing navigation links
  15. Different ‘posts_per_page’ setting for first, and rest of the paginated pages?
  16. How to paginate wordpress [gallery] shortcode?
  17. Pagination returns 404 after page 20
  18. paginate_links() adds empty href to first page and previous link
  19. paginate_links ignore my format
  20. how does $wpdb differ to WP_Query?
  21. Combining two wordpress queries with pagination is not working
  22. Custom WP_Query order by post_meta and (author) user_meta
  23. Is it true $wpdb->get_results is faster than WP_Query in most cases?
  24. How to paginate attachments in a secondary query as gallery?
  25. Pagination with WP_Query is buggy – working for some pages, but not the others
  26. Get the number of posts from the current page results
  27. WP_Query and Pagination on a Static front page
  28. next_posts_link not working for loop called with ajax
  29. Why does pagination always break when used on any form of a home page?
  30. Use WP_Query with a custom SQL query
  31. Pagination with 5 posts per page
  32. Pagination shows 404 after a certain number of pages
  33. Pagination custom query
  34. How to make an activities stream mixing posts and comments?
  35. Pagination not working for Custom search form & custom result template
  36. Pagination/infinite scroll with WP_Query and multiple loops
  37. How can I connect to another WP database and use WP_Query?
  38. How to adjust found_posts so that it accounts for offset and pagination
  39. Pagination broken when merging search results with additional WP_Query
  40. WP_query and pagination?
  41. pagenavi with merged wp_query [duplicate]
  42. Add and in the header while looping over custom query in page template
  43. pagination doesn’t show up for custom post type
  44. Pagination causes error 404 when used with front-page.php
  45. Paginated pages are showing correct content but pagination links are not
  46. Query with pre_get_posts to get pagination
  47. Pagination wont work with search results template [duplicate]
  48. Pagination Not working on Home Page with 2 Query
  49. Best Practice For Querying Grandchildren?
  50. Pagination not working on static page
  51. ‘paged’ in wp_query doesn’t work
  52. Display different number of posts from one category on the different pages
  53. Pagination not working Search posts
  54. Get number of comments after modifying comment query
  55. How to change a custom query into a standard loop?
  56. Pagination not working for category posts
  57. Pagination is not working using WP_Query
  58. WP Query with offset breaks wp_pagenavi or any pagination
  59. Search – Ajax – Alter Query Parameters with Pagination
  60. Two queries on the same page with pagination
  61. Transient pagination not working properly
  62. Injecting content with $wp_query->current_post restarts from zero on paged pages. How to inject content after X posts, regardless of pagination?
  63. Show single post then all posts (with pagination)
  64. Is there a PHP function that can match anything after the given URL, so my IF statement will work in each instance?
  65. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  66. Add custom search results to main WP search [duplicate]
  67. Woocommerce custom loop to show all the products [closed]
  68. How to bring specific post to front of wordpress loop?
  69. Pagination for custom query on single.php
  70. Merged two WP_Queries, posts per page and pagination not working
  71. Pagination doesn’t work in custom page template [duplicate]
  72. Should close $wpdb via $wpdb->close()
  73. Intentionally exceed max_num_pages on main query without getting 404?
  74. WP_Query pagination not working in admin area
  75. Pagination 404 errors for author posts query on author.php
  76. WordPress pagination link always leads to home page
  77. $wpdb->insert inserting two rows in database
  78. WP_QUERY loop, offset in the arguments and the paginate_links – can these work together?
  79. Pagination problem after WP_Query with tag filtering
  80. Too many posts cause slow load when paginating
  81. Pagination stops at page 6
  82. Paginated HTML Sitemap
  83. How to output different posts per page?
  84. Multiple WP_Query loops with Pagination Not Working
  85. Get the Plugin Which Triggered a MySql Query in WordPress?
  86. Posts loop with pagination on a single post page
  87. Custom pagination with WP_Query generating 404 error
  88. Pagination working everywhere but the index page
  89. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  90. Detect featured image among the attached images
  91. How would I format a query that depends on post parent taxonomy
  92. Mysql query LIKE not working
  93. Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
  94. Select from wp_post and multiple meta_value from wp_postmeta
  95. Order by custom table and multiplication
  96. WP_Query ajax loader detect end of posts
  97. Offset Page Loops and Pagination
  98. Pagination is broken and I need help fixing it
  99. How to correctly pass values to wpdb->prepare()?
  100. $wpdb select date range of posts

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)