WordPress Core – Optimizing meta_query generated SQL?

In case I am right about that possible optimisation, I have opened a ticket on Trac and submitted a patch: http://core.trac.wordpress.org/ticket/26281

My plugin’s page query time goes from 10+ seconds to 20ms… I hope there are no edge cases.

Related Posts:

  1. How to do a meta query using REST-API in WordPress 4.7+?
  2. Meta query terribly slow
  3. meta_query sorting by 2 keys
  4. Get result from meta_query() between two numbers
  5. How to handle optional end date in compare clause in meta_query
  6. Using meta_query on pre_get_posts to exclude a particular meta_key value
  7. Query between two meta keys
  8. Archives for custom post type based on a “date” meta value
  9. How to check a single number value against an array of meta_key values?
  10. get_users meta_query
  11. Meta query with multiple logic (AND / OR)
  12. Best practice – Meta Query vs. post_clauses for “left join” ordering
  13. meta_query with multiple values
  14. Different page parameters inside query
  15. Return posts with specific meta key first, but the rest in alpha order by last name
  16. meta_query key value from array
  17. LIKE %…% Meta Query
  18. Multiple Values stored as array in Meta Query
  19. Order by nested named meta queries with ‘exists’ and ‘not exists’
  20. Documentation for post meta
  21. Advanced orderby with multiple meta_query
  22. Arrange Posts By Date In Order Of Closest To The Current Date
  23. Using get_terms() with meta_query parameters
  24. WP_User_Query with meta_query array relation ‘OR’
  25. meta_query problem
  26. Custom Upcoming Events List for Events Manager Plugin
  27. Very slow query with meta_query on large database
  28. How to use meta_query to check if a meta field has something set?
  29. How to exlude posts that have certain meta_value?
  30. User Relationship
  31. meta_query results not the same with and without spaces
  32. meta_query all posts between to ages
  33. How to make a WP REST API query with meta_query in WP4.7?
  34. Edit post_content on posts with Featured Image
  35. Nested Queries using meta_query
  36. Display no post when metavalue is 0
  37. Use both meta query and tax query
  38. Wildcard with LIKE operator in Meta query
  39. meta_query, number comparison, not quite working as it should
  40. Meta Query Compare with Date
  41. Query posts only if meta_value is not empty
  42. Does meta_query working with value paramater higher then 999?
  43. meta_query keys and sticky posts
  44. How to pass user meta_key and meta_value (values as array)
  45. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  46. Query Multiple values for same key
  47. Custom post type archive with rand and meta_value
  48. Comparing a field with several values at once with meta_query
  49. Meta query with a sub query group possible?
  50. meta_query compare=’!=’ with multiple custom fields
  51. Query posts with numeric meta values within a given range
  52. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  53. meta_query not working on live site
  54. How to query post only with different excerpt?
  55. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  56. Query custom field with date
  57. Meta query with regular expression does not work
  58. Searching in title or meta, with a tax query too!
  59. WP_Query with meta_query no results
  60. Documentation for post meta
  61. WP User Query Issues
  62. How to use meta query for greater than value in array?
  63. Wp Query custom search by meta query
  64. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  65. Filter posts by meta query?
  66. Help on multiple meta_query
  67. Meta query – How to display a null meta key
  68. pre_get_posts and set
  69. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  70. How to query wp_postmeta table for any specific meta_value?
  71. User meta query results in PHP notice: only variables should be passed by reference
  72. meta_query with multiple values optimization
  73. Meta query date column add [x] days to validate
  74. Get a single post ID based on an exact match of 1 or more meta values
  75. How to use orderby with meta_query?
  76. wordpress Meta_query between numbers range (not working)
  77. meta_query with multiple key
  78. Orderby doesn’t work like expected on custom query
  79. I would like to have add_post_meta to return the ID instead of true or false
  80. Order by meta value
  81. last_name + first_name orderby with meta_query [solved]
  82. meta query based on month regardless of year
  83. Extend meta query arguments
  84. get_posts( $args ) return empty data
  85. meta_query in WP_User_Query not working – returns every user, not just users where key & value matches
  86. meta query or with meta value
  87. how to get post meta where value is an array of key value pairs
  88. meta_query array in ‘values’ returns an error
  89. Meta Query Based on Month Range
  90. how to search all user meta data that have value like “vivek”
  91. Find posts by related taxonomy field
  92. wordpress meta value compare between two date
  93. Can I use pre_get_posts to add up values from two different meta_keys?
  94. WP JSON API meta_query not working
  95. get_users with Serialized Custom Meta Value
  96. Sorting posts by ACF field
  97. Ordering custom posts by meta field date
  98. Unable to use meta_query between currency values when value is over 1 million
  99. latitude/longitude meta_query
  100. Filtering all posts AND sticky posts through meta_query
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)