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. When should you use WP_Query vs query_posts() vs get_posts()?
  27. How to query for most viewed posts and show top 5
  28. Differences Between WP_Query() and get_posts() for Querying Posts?
  29. Add indexing to meta_value in wp_postmeta
  30. Custom WP_Query order by post_meta and (author) user_meta
  31. WP_Query for WooCommerce Products
  32. Get posts by menu ID
  33. Export wordpress table to excel
  34. Perform query with meta_value date
  35. get_the_title($postID) OR get_the_title()?
  36. Add and in the header while looping over custom query in page template
  37. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  38. How to find if a post with custom_field == X exists?
  39. How to speed up wp_query, took more 5s to run against 100k posts
  40. Transient caching for wp query
  41. How do you query wordpress posts using a math formula between multiple meta field values?
  42. Custom Post order for homepage
  43. Page navigation doesn’t show when query category
  44. Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
  45. Query all published post AND attachment with specific mime type
  46. Add quicklink to in the Admin posts page where I can query by a meta_key
  47. Get all products which have both product category
  48. unable to retrive parent page information
  49. Fastest way of counting posts of a custom post type in a specific taxonomy term?
  50. Use more than one query, but prevent duplicates – at scale!
  51. Is it a good idea to improve meta query performance by adding tax query?
  52. How to display user order by role
  53. How to use the query hook/filter?
  54. WP Query related posts by tags
  55. Order by summing multiple values
  56. Check if loop has any categories?
  57. How to access custom WordPress database tables
  58. Query only the posts with a post format of “audio”
  59. pre_get_posts – Trying to get property of non-object warning
  60. WordPress query posts with multiple post_meta data
  61. Update query for wp_posts and wp_postmeta
  62. Slow Query On Search
  63. WP_Query with page_ids in arguments without a result
  64. Write WP Query that selects posts that are part of the same two categories
  65. Insert images into wordpress post with a query
  66. WP_Query meta compare must include ALL array values
  67. Prioritising and Ordering Posts By Category Name Using A Custom Loop
  68. Filter products on category AND tag
  69. Why last row deleted when refresh page
  70. pre_user_query vs pre_get_posts
  71. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  72. Query a database based on form input then output to another page [closed]
  73. Adding nofollow to all the post links in get_posts with pre_get_posts or WP_Query
  74. Meta query orderby meta_value_num sorting by role first
  75. How to extend WP_query to a specific table?
  76. Add to search posts query array with post IDS which will appear first
  77. Query by meta value (add a dropdown of all values)
  78. How to show terms from another taxonomy
  79. Showing the correct number of posts_per_page when avoiding the use of post__not_in
  80. My entry results are not consistently alphabetized
  81. Ignoring ‘a’ when sorting posts
  82. Custom query for tag and custom tag from 2 post type
  83. WP_Query secondary query failing
  84. Search Functionality broken by the wp 4.2 update
  85. Issue attempting a wp_query_posts with tags
  86. wp_query – Modify $query to include duplicate content
  87. add_query_vars does not work
  88. Divide WP_Query posts by date & post type
  89. Retrieve posts in custom post type and specific taxonomies
  90. New WordPress WP Query using posts from certain categories
  91. Get the number of rows from $wpdb->get_results not working
  92. Get Child Custom Post Content on Single.php?
  93. How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
  94. WordPress Admin Page Slow. Customer Post Type is the slowest
  95. Pre_get_post on CPT archive page
  96. Get posts that were most recently tagged
  97. SQL query into to WP query
  98. Use meta query only 3 or more results?
  99. Search results stuck on page 1
  100. Use value from meta key array for use in WP_Query