WP_Query with many meta_query arguments taking a long time to load

Yeah I can imagine that query is going to be a doozy.

The main reason for that is that every extra condition against a post meta value might be causing an extra SQL JOIN between the wp_posts table and the wp_posts table, and JOINS can get exponentially expensive. I’m surprised it even comes back in a minute if you select all those options. And this problem will get worse as the size of your wp_postmeta table grows.

Saying that, it’s not clear why you’re using LIKE here instead of = for the compare value, unless you really do need to match strings that contain the value parameter? That might make a big difference in the speed as LIKE is more expensive than = in SQL.

Other than that, because of the way this query works internally in WP_Query you might have a hard time making it go any faster. You might be at the point where you need a different data structure, or to do something more custom away from using WP_Query and the key-value structure of the wp_postmeta table. Or you could look at limiting the number of these options that users can pick.

HTH

Related Posts:

  1. Pagination not working for Custom search form & custom result template
  2. Using AJAX to return search form results
  3. Taxonomy search/filter with multiple taxonomies and multiple taxonomy terms
  4. WordPress Ajax form filter | Search by title with ajax form, breaks the other filters
  5. Form checkbox value going to dynamic URL
  6. WordPress custom search form – ignore empty/default input fields upon submission?
  7. Query a database based on form input then output to another page [closed]
  8. whether a nonce is required for get type and get_query_var?
  9. WordPress – Form does not filter the results of taxonomies
  10. Help with showing text when something is entered in my search bar
  11. How do I query for posts by partial meta key?
  12. WP_Query orderby date not working
  13. Display products from specific category in shop page
  14. meta_query where value is equal to given value
  15. Query by meta_key and order by meta_value_num return orderby date
  16. How can I hide posts that are over 2 years old
  17. WordPress custom search form with pre_get_posts not work
  18. wp_query, give first post different formatting
  19. WordPress: Keep order of query_posts list of post ID’s using post__in
  20. Best practice custom function, where to echo the variables?
  21. How to get user_id from wordpress database inside ajax function?
  22. Retrieving list of a custom post type in a widget without using WP_Query?
  23. Order WP_Query by multiple fields, subtracting them from one another
  24. How can I convert results of WP_Query (of Custom Post Type, with Custom Fields) to JavaScript?
  25. Query with custom taxonomy not working
  26. Query posts by specific word on title
  27. Date and Category query with filter
  28. How to order posts in wp_query by the user role (2 roles in array)
  29. How to change main query based on post meta
  30. add active class based on permalink and url
  31. Loop Split two Columns
  32. Search by post id in a specific page then auto-redirect to searched post
  33. Pretty urls for custom pagination
  34. WP_Query with ‘rand’, but equal number of posts from the taxonomy terms given
  35. use of 10 new WP_Query : loading too slow (with url) [closed]
  36. How to make a second query offset -2 from current post
  37. slow query – Search for Media Gallery
  38. How to not display tags with less than X posts
  39. WordPress has a list of reserved words, can I override them, to use one in a query string?
  40. Wp_query with 2 meta keys and array of meta values
  41. meta_query: check if number exists
  42. How to order WP_Query to group results?
  43. Search Page Returns Nothing
  44. Create a loop on my pages with new “WP_Query”
  45. Which meta_query and post_content blend is better in WP_Query, performance wise?
  46. WP Query causing timeout
  47. WP ForLoop to compare meta information of posts to determine what post to display
  48. Problem with get_page_by_path() using with WP_Query
  49. Query where ANDing slug values not working
  50. Woo Commerce using WP_Query to get products that match price range, with an additional required product attribute
  51. change posts_orderby of the callback wp_query?
  52. Retrieve select tag custom values from array and display them in current page with wp_query?
  53. How to use a dropdown to filter posts by custom field
  54. Content not displaying on paginated page
  55. show custom category posts from a custom post type
  56. how to load posts to a custom post template after using template_redirect or template_include
  57. 2 queries with counters
  58. Trying to use WP_Query to display a custom post type
  59. WP Query / Meta Query [duplicate]
  60. Multiple Query_Posts
  61. Page template doesn’t display simple HTML if inserted into other page?
  62. Query multiple post types, but different order for each
  63. How to add date_query to meta_query array
  64. Order by the first array within a meta_query
  65. View list of custom posts within a date range relative to today’s date, based on a custom date field
  66. Multiple nested meta queries
  67. Comparing Meta Field date in WPQuery using Meta_Query?
  68. Fix wp_term_relationships slow query in get_posts
  69. Custom query for custom post type not getting correct post ID
  70. How to merge these two post queries?
  71. How to search posts by title with special characters in WP_Query?
  72. How can I query a radius of coordinates?
  73. Query postmeta based on meta_value, return array of post_id
  74. WP_Query: Query posts only if their access is restricted to logged user’s role
  75. datetime picker, timestamps and meta queries
  76. Get specific value from variable to use in query
  77. WP_Query with meta_query won’t orderby
  78. Adding Category in WP_Query Not Working
  79. Meta key in wp_query bug?
  80. display all posts from category with and without terms in chronological order
  81. How to create page that lists tags by initial letter?
  82. How can I create another instance of my custom shortcode
  83. How To Call WP_Query From A Subdomain?
  84. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  85. WordPress: Cron locking and Queue
  86. Correct Way To Run Multiple Queries Sharing Some Base Data
  87. how to query for meta_value have array
  88. How to make the default WordPress search return borader results
  89. WP_Query shows all posts on single post pages
  90. Show sticky post before other WP_Query
  91. List ALL posts within last week from current category on category page
  92. WP_Query on “property” in the options table
  93. Post OrderBy slow performance
  94. Dynamically name array in WordPress loop – add/get values
  95. Creating Custom Query
  96. Hook to get the query result after listing posts
  97. Elementor custom query
  98. How to get all post_id and meta_value using meta_key in wp_postmeta table
  99. How can I get taxonomy term name using term slug & post ID using build in WordPress function or class?
  100. Why does wp_query only display the most recent post when using order ASC?

Leave a Comment