Slow SQL_CALC_FOUND_ROWS Query

The use of SQL_CALC_FOUND_ROWS is not really a problem, although it incurs an overhead.

What happens is, WordPress uses SQL_CALC_FOUND_ROWS in order to determine the total posts that would have been returned, if no LIMIT clause was provided. This is necessary in order to calculate and provide you with correct pagination links.

Disabling it unconditionally is guaranteed to break things all over the place.

If you can identify specific queries that suffer from its use, and you can do without pagination, then you could hook to pre_get_posts and conditionally set the no_found_rows parameter to true.
This, however, is more a hack than a solution.

The proper solution is to use a database query caching mechanism, either on the side of the database, or on the WordPress side using a plugin such as Advanced Post Cache (developed for and used in WordPress.com)

Related Posts:

  1. Should I use Transients with W3 Total Cache APC Caching? [closed]
  2. Get posts by menu ID
  3. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  4. WP_Query Performance Issues with meta_query
  5. Improve wp query perfomance on large db
  6. Order by custom table and multiplication
  7. Single meta_query query using OR instead of AND in request’s WHERE statement
  8. why update and delete query not worked in custom table?
  9. How to implement a new row_count method in WordPress?
  10. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  11. how to get Nearby zipcode
  12. How I can change the condition or compare operator for WP_Query in pre_get_posts
  13. WP_Query with page_ids in arguments without a result
  14. Why last row deleted when refresh page
  15. Fix wp_term_relationships slow query in get_posts
  16. update_post_meta performance in a loop woocommerce
  17. update_post_meta performance in a loop woocommerce
  18. WP_Term_Query->get_terms() very slow query for WordPress filter
  19. Website goes slow down after importing long database
  20. WP_Query always returning the last custom post
  21. Optimising amount of calls to custom fields
  22. SQL query into to WP query
  23. When to use WP_query(), query_posts() and pre_get_posts
  24. Should I use Pre Get Posts or WP_Query
  25. Using pre_get_posts with WP_Query
  26. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  27. Return only Count from a wp_query request?
  28. Use REGEXP in WP_Query meta_query key
  29. WP_Query orderby post__in remains ineffective in the Loop [closed]
  30. What is “main query”? [duplicate]
  31. Order by DESC, ASC in custom WP_Query
  32. How to prevent execution of default query, while preserving ability to use WP_Query in template?
  33. WordPress database scalability from the code perspective
  34. Reduce or prevent calling of update_meta_cache
  35. How to add taxonomy filter on the query fly?
  36. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  37. Differences Between WP_Query() and get_posts() for Querying Posts?
  38. How to uniquely identify queries?
  39. What is the most efficient way of querying posts based on visits and date for current day?
  40. Add indexing to meta_value in wp_postmeta
  41. Order Search Results Page by meta_value If no Value Return Remaining Results
  42. Getting wrong relationship value in $args in wp_Query?
  43. find a random blogid across my multisite network that has at least one post published
  44. pre_get_posts with get_posts
  45. Is it true $wpdb->get_results is faster than WP_Query in most cases?
  46. How-to exclude terms from the main query the most performant way?
  47. Changing Posts Per Page and offset with pre_get_posts
  48. “pre_get_posts” firing on every query
  49. RSS feed with specific keyword
  50. WordPress for a very large website
  51. Using is_main_query to select custom post type on certain page
  52. get_the_title($postID) OR get_the_title()?
  53. Multiple orderby parameters in pre_get_posts() action
  54. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  55. SQL Statement generated by WP_Query not producing expected results
  56. What is an efficient way to query based on post_meta?
  57. SQL query equivalent to WP User Query
  58. What’s wrong with this WP query?
  59. How to count post meta key values for all posts in database
  60. Sorting Posts by custom field
  61. How to pass custom parameter to WP_Query for filtering in pre_get_posts
  62. Query with pre_get_posts to get pagination
  63. Group posts by meta_key
  64. Recommended way to drop a pending query (in pre_get_posts)?
  65. How to search for posts IN OR title OR content OR author?
  66. How to solve slow WordPress site caused by attachment_metadata
  67. Single page theme that uses pages for the content
  68. WP_Query hit max joins… How else can I build a search function that uses custom fields?
  69. WordPress custom search form with pre_get_posts not work
  70. Would this post meta be better added to the post table rather than post_meta table
  71. If orderby parameter using pre_get_posts is the same for multiple posts what fallback does the query use?
  72. Can not switch the queried post in pre_get_posts hook
  73. Slow speed and high CPU usage for my code. How to improve it?
  74. Multiple queries on Home Page – page load/site speed issue
  75. How to target the default Recent Posts and Recent Comments widgets with pre_get_posts?
  76. How to find if a post with custom_field == X exists?
  77. order by multiple meta keys in pre_get_posts
  78. Order By Multiple Meta Fields
  79. meta_query on a date range using an array of values
  80. Changing BIGINT to INT
  81. if statement on database query
  82. Should close $wpdb via $wpdb->close()
  83. How to speed up wp_query, took more 5s to run against 100k posts
  84. How to sort posts in admin by titles with dd.mm.yyyy format?
  85. Get the post permalink within the loop but without additional DB query
  86. WP_Tax_Query with post_tag not working
  87. Filter WordPress posts by between parameter
  88. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  89. Database slowdown after update to 3.4.1
  90. SQL User Query by Multiple Roles using PHP
  91. How to Modify Taxonomy Archive Page with Search Parameter?
  92. Using pre_get_posts on a specific core/query block
  93. Retrieve featured image (thumbnail) url from multiple posts with one query
  94. WordPress Query is taking more then 20 second and stuck on creating index
  95. Searching through different categories on different pages code is not working
  96. How to display future posts – modified query still yields 404
  97. Too many posts cause slow load when paginating
  98. Get the Plugin Which Triggered a MySql Query in WordPress?
  99. pre_get_posts filter meta_query without conflicting existing meta_query
  100. Including only current user’s posts in search

Leave a Comment

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