multiple meta key but get server load is very high

Complex meta queries with a large number of meta values to find can be slow. Each meta key you query for generates one more JOIN in the query, and if you have a large database, it can be slow. You can try few things:

  • Optimize your database tables, it is possible that you have a lot of orphaned data that can contribute to database query speed.
  • Try limiting the number of posts query returns, if you have a lot of records in the results set that can cause speed problems too.
  • Contact your hosting (or do it yourself if you have access) to check MySQL slow query log to see why the query is slow, and maybe do some optimization on the MySQL server settings for better caching.

Related Posts:

  1. meta_query with meta values as serialize arrays
  2. Use REGEXP in WP_Query meta_query key
  3. Set Alias for meta_query arguments in get_posts()
  4. How to Compare Two Meta Fields
  5. Is it possible to orderby multiple meta_keys when using meta_value_num?
  6. Getting attachments by meta value
  7. Using custom meta_query with relation not working as expected
  8. WP_Query meta_query where meta value ends in space
  9. Nested query inside Logical operator OR not working in meta_query
  10. What is an efficient way to query based on post_meta?
  11. How do I create my own nested meta_query using posts_where / posts_join?
  12. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  13. Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
  14. Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
  15. Exclude post on loop by multiple meta key value
  16. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  17. How to get sum of meta_values of a meta_key in wp_query according to conditions
  18. meta_key and meta_value not working together
  19. Order posts by meta value and Date
  20. Query sticky posts with thumbnails
  21. Order WP Query posts by custom order calculated from post meta values
  22. how to speed up a complex wp_query?
  23. Meta query with order by another custom field
  24. How to query for custom field within Gutenberg block from outside of that post? [closed]
  25. Meta Query for specific months
  26. Meta query with JSON value
  27. Get meta info related to current post
  28. Creating arguments from loop for WP_Query meta_query
  29. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  30. Single meta_query query using OR instead of AND in request’s WHERE statement
  31. How to do meta_query for attachments?
  32. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  33. Get attachment by meta_key value
  34. Using meta_query with multiple keys and compare values
  35. Why isn’t my `meta_query` array functioning properly?
  36. Overwrite YoastSEO meta-tags with another page’s [closed]
  37. How to orderby multiple meta fields if some fields are empty
  38. Suggestions on making this query/code more performant
  39. Is it possible to set specific posts to show first in a query?
  40. Order by meta value (numeric value lower to higher)
  41. Large AND OR query timing out
  42. Order ascending is ignored in meta query?
  43. WP_Query with different postmeta filter for each categories
  44. Slow WP_Query with ‘OR’ on meta_query
  45. Query posts with “non set” meta value
  46. Query with meta_query and tax_query together not working properly
  47. Array as ‘key’ in WP_Query
  48. Ordering a mysql style datetime stamp with meta_query
  49. Is it possible to query a custom field where the value is between two fields?
  50. Filter posts by comparing custom meta value against postdate
  51. Wp_query with 2 meta keys and array of meta values
  52. meta_query: check if number exists
  53. Searching for meta_key returns 0 posts
  54. meta_query fails to compare on values containing apostrophes
  55. Check if searched number is within the post meta value
  56. add_query_arg to compare and display events from a certain date
  57. WP Query / Meta Query [duplicate]
  58. Query posts by searching for a string in a meta field
  59. WP_Query not returning correct result with meta_query parameter
  60. Query multiple post types, but different order for each
  61. How to add date_query to meta_query array
  62. Order by the first array within a meta_query
  63. Query ACF relationship field – Comparator IN – Value array
  64. Query on meta values and post title
  65. Multiple nested meta queries
  66. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  67. How do i create a custom post query when the meta value is an array?
  68. How can I modify the query by adding to the existing query?
  69. Custom Meta Query doesn’t work the same on two site
  70. WP Query – grouping posts by same meta key, adding together values from another key
  71. How to do WP_User_Query for Nested Array value Inside Nested Array field
  72. Query for current post
  73. Custom query to retrieve oldest post and retrieve others with date interval
  74. Comparing Meta Field date in WPQuery using Meta_Query?
  75. Very slow query generated getting meta data from posts
  76. How to filter on placeholder image
  77. Filtering WP_Query based on wp_postmeta keys values
  78. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  79. Multiple meta_query not working
  80. compare for multiple meta values for same key in wp_query
  81. datetime picker, timestamps and meta queries
  82. WP_Query with meta_query won’t orderby
  83. meta_query only check if both value are set
  84. What is the best way to reset a search on a meta_key / meta_value?
  85. Slow query when selecting with large meta query or post__in
  86. WP Meta Query at depth 2
  87. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  88. Using custom field as ‘orderby’ value causing post grouping by publish date
  89. Is there any difference between below WP_Query code snippets?
  90. Sorting: custom query with orderby meta_value_num THEN by title
  91. meta_query compare not doing what I want it to do
  92. Creating Custom Query
  93. Can’t figure out query logic
  94. WP_Query orderby not working on custom post_type
  95. WP_Query by meta key not returning any posts
  96. How to get all post_id and meta_value using meta_key in wp_postmeta table
  97. WP Query – Show custom posts only if user contain some user meta
  98. How do I subquery with custom meta fields?
  99. Showing Counts on Comment List with Custom Query
  100. How to get products with the same custom attribute like ean code

Leave a Comment