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. Meta query terribly slow
  2. Get result from meta_query() between two numbers
  3. Query between two meta keys
  4. Archives for custom post type based on a “date” meta value
  5. How to check a single number value against an array of meta_key values?
  6. get_users meta_query
  7. Meta query with multiple logic (AND / OR)
  8. meta_query with multiple values
  9. Return posts with specific meta key first, but the rest in alpha order by last name
  10. LIKE %…% Meta Query
  11. Multiple Values stored as array in Meta Query
  12. Documentation for post meta
  13. Advanced orderby with multiple meta_query
  14. Using get_terms() with meta_query parameters
  15. WP_User_Query with meta_query array relation ‘OR’
  16. meta_query problem
  17. Very slow query with meta_query on large database
  18. How to exlude posts that have certain meta_value?
  19. meta_query results not the same with and without spaces
  20. meta_query all posts between to ages
  21. Nested Queries using meta_query
  22. Display no post when metavalue is 0
  23. Wildcard with LIKE operator in Meta query
  24. Meta Query Compare with Date
  25. Query posts only if meta_value is not empty
  26. Does meta_query working with value paramater higher then 999?
  27. meta_query keys and sticky posts
  28. How to pass user meta_key and meta_value (values as array)
  29. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  30. Query Multiple values for same key
  31. Custom post type archive with rand and meta_value
  32. Comparing a field with several values at once with meta_query
  33. Meta query with a sub query group possible?
  34. meta_query not working on live site
  35. How to query post only with different excerpt?
  36. Query custom field with date
  37. Meta query with regular expression does not work
  38. Searching in title or meta, with a tax query too!
  39. WP_Query with meta_query no results
  40. Documentation for post meta
  41. Wp Query custom search by meta query
  42. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  43. Meta query – How to display a null meta key
  44. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  45. How to query wp_postmeta table for any specific meta_value?
  46. User meta query results in PHP notice: only variables should be passed by reference
  47. meta_query with multiple values optimization
  48. Meta query date column add [x] days to validate
  49. Get a single post ID based on an exact match of 1 or more meta values
  50. wordpress Meta_query between numbers range (not working)
  51. meta_query with multiple key
  52. Orderby doesn’t work like expected on custom query
  53. I would like to have add_post_meta to return the ID instead of true or false
  54. Order by meta value
  55. meta query based on month regardless of year
  56. Extend meta query arguments
  57. get_posts( $args ) return empty data
  58. meta_query in WP_User_Query not working – returns every user, not just users where key & value matches
  59. meta query or with meta value
  60. meta_query array in ‘values’ returns an error
  61. how to search all user meta data that have value like “vivek”
  62. get_users with Serialized Custom Meta Value
  63. Unable to use meta_query between currency values when value is over 1 million
  64. Filtering all posts AND sticky posts through meta_query
  65. How to cache the results of a query and display the cached results
  66. How to Ordering by user meta
  67. How to send variable to wp meta_query value?
  68. get_user can’t read variable
  69. meta_query check multiple date formats
  70. How to count items of meta query?
  71. WordPress meta query with meta serialized data array value
  72. Reading Content in an Array as it relates to a meta_query
  73. wordpress meta query with multiple meta condition causing a load on server and slows down the server..!
  74. Meta_Query with multi select values
  75. Trouble with calling an imploded variable in an array
  76. Memory Leak in Processing Large JSON file
  77. Meta Query returning empty array
  78. Query for user roles and their skills
  79. Get Posts from Custom Meta Query
  80. like_escape notice when using LIKE in meta query
  81. meta_query for user ID in array
  82. Display query post based on two orderby value in wordpress
  83. How to fetch WP_User_Query with multiple role arguments [duplicate]
  84. How to get meta value based on latest post id with group by term name
  85. Querying by meta key and value
  86. How to compare date in post meta value
  87. Multiple Queries with meta_query
  88. Which Meta Query Compare Method Should I use?
  89. Sort posts by post views and consider meta key
  90. How to output meta_key in wp_postmeta?
  91. meta_query and strange orderby behaviour
  92. Sorting not working with get_posts
  93. Get_term with meta_query
  94. Meta query with string NOT ending like pattern
  95. ACF meta_query field treated as “0” resulting in false negative search when testing ranges
  96. acf/save_post affecting WP_Query results
  97. Merge meta_value’s into a single row and then loop
  98. Is it possible to customize meta query in this way?
  99. How making a new search box in admin post table working on a specific column
  100. wp_user_query with meta_value_num for leaderboard