WP_Query Performance Issues with meta_query

Custom field data is stored in the postmeta table, and it’s likely that scanning through this table is causing slowness.

You should:

  • install the debug bar plugin which will give you more insight into the queries that are being executed against the database – you’ll be able to see how long each query takes, and the actual SQL code that’s being executed.
  • Find the queries that are taking a long time to run, and EXPLAIN them. This will give you a much better idea of what’s going on, and how to proceed.

Related Posts:

  1. Should I use Transients with W3 Total Cache APC Caching? [closed]
  2. What is the most efficient way of querying posts based on visits and date for current day?
  3. Slow SQL_CALC_FOUND_ROWS Query
  4. Transient pagination not working properly
  5. Get the post permalink within the loop but without additional DB query
  6. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  7. Minimize database queries to user tables?
  8. Slow page loads due to WordPress Core Query
  9. No results found from a $wpdb->get_results() query when trying to join more than one meta key query
  10. Transient api Caches confused
  11. Is it possible to query from external database? [duplicate]
  12. What is the best way (regarding performance) to set transients for logged in users?
  13. How to set up hierarchical relationships without using plugins / meta query
  14. Using Transients
  15. I am officially missing something about transient posts
  16. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  17. How to get meta key list efficiently?
  18. update_post_meta performance in a loop woocommerce
  19. update_post_meta performance in a loop woocommerce
  20. WP_Term_Query->get_terms() very slow query for WordPress filter
  21. wpdb get_results() returns only 2 rows
  22. Website goes slow down after importing long database
  23. WP_Query always returning the last custom post
  24. Optimising amount of calls to custom fields
  25. how to use transient method?
  26. Make a WP Query search match exactly the search term
  27. WP_Query: query posts by ids from array?
  28. Query WooCommerce orders where meta data does not exist
  29. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  30. Show only oldest post by author
  31. How to get the posts published in last two days using WP_Query?
  32. Dynamically Override Fancy Title – Part II
  33. Can not switch the queried post in pre_get_posts hook
  34. How to detect custom query inside `posts_where` hook?
  35. Pass the same object to multiple widgets in a template with one query
  36. Is temporarily overwriting $wp_query a bad idea?
  37. What is considered a default query for the request filter?
  38. $wpdb insert is not work
  39. Pass array of taxonomy terms to wp_query
  40. How WordPress attaches its Featured Images with posts?
  41. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  42. Improve wp query perfomance on large db
  43. How to query a custom post type with a taxonomy filter but display post type archive page?
  44. reducing the amount of wp_query calls
  45. List of the years with posts presented
  46. Set Transient does nothing
  47. Change query_posts to WP_Query in page but does not work
  48. Optional Meta Query
  49. Set conditional on template based on referring page slug
  50. Editing the default wordpress search
  51. Iterating through $wpdb query without using get_results for large query results
  52. Filter posts in category archive page by year using a dropdown
  53. Set global $wp_query/$post variable for dynamic page generation
  54. Loop Performance > JSON files vs. WP_Query vs. REST API
  55. Include data from custom table in WP_Query
  56. How to get a query variable?
  57. date_query seems to be ignored by wp_query
  58. Query Page Content From Theme Options?
  59. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  60. Better wordpress attachment query than this
  61. Transients with dynamic WP_Query
  62. Modify Search Query if original Query gave no results
  63. How to cache wp_query with pagination using transients?
  64. Include current post into loop
  65. Can’t sort custom post type by random
  66. Filter post query to only show direct children of category
  67. how to get Nearby zipcode
  68. Wpdb->query result show 1 but is not an integer
  69. Storing an array of objects related to each user
  70. Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
  71. WP_User_Query orderby meta_val_num
  72. WP_Query custom order and pagination
  73. Unable to paginate a custom page query
  74. meta_query where the meta value is not the post title
  75. Query pages created by deleted users
  76. Woocommerce Get Orders By Meta Value
  77. Save large WP_Query to transient === false
  78. Exclude post from wp_query based on custom field boolean
  79. Get posts that match defined arrays of tags
  80. How select query is generated in a Custom Post Type?
  81. Order posts by tags count?
  82. Strange results from WP_Query
  83. Is there a way to control both Order By and Order query parameters from one input field
  84. I need query_posts() to order results first by a meta value and then by post ID
  85. return child post if available otherwise parent post
  86. Search has query that will return no results
  87. WP Query – Search in title or author_name
  88. URL to Post Archive of Custom Query
  89. orderby in WP_QUERY – Use the order from the Dashboard
  90. Random posts in WP_Query when searching by tag
  91. Ordering Posts by parent category, name ascending
  92. Set Transient on CPT
  93. How to query post into a complex slider
  94. Combine privileged users array with my current query
  95. Horizontally paginate through sets of blog posts?
  96. Need help setting up a search form for wordpress [duplicate]
  97. meta_query dates from an array
  98. wp_query order by rand is repeating posts
  99. Modify WordPress Search
  100. $wp_query->found_posts; returns zero