Nested query inside Logical operator OR not working in meta_query

I can see from above query that you are willing to do following thing.

Get all post if property_size is 15 AND property-type is marla OR Kanal.

The SQL will be like %marla% OR like %Kanal% this is equivalent to like %marla Kanal% this will not make much difference (I assume)

So you can minimize this query in this way 

$compare_array = array(
    'relation' => 'AND',
    array(
        'key'       => 'property_size',
        'value'     => '15',
        'type'      => 'numeric',
        'compare'   => '='
    ),
    array(
        'key'       => 'property-type',
        'value'     => 'marla Kanal',
        'type'      => 'CHAR',
        'compare'   => 'LIKE'
    )
);

In my testing it reduce the query time by 428 ms

SQL like is expensive so if you are matching exact value then use IN with array of values.

array(
        'key'       => 'property-type',
        'value'     =>  array('marla', 'Kanal'),
        'type'      => 'CHAR',
        'compare'   => 'IN'
    )

Related Posts:

  1. WP Query Args – Title or Meta Value
  2. Meta query with string starting like pattern
  3. how to show posts that are missing a meta_value
  4. Does tax_query really beats meta_query in all situations?
  5. Query WooCommerce orders where meta data does not exist
  6. Execute a large WP_Query with many “AND” Meta_Queries?
  7. Query all posts where meta value is empty
  8. WP_Query min and max values
  9. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  10. querying with custom meta field with meta_query
  11. Order by two meta keys
  12. multiple meta key but get server load is very high
  13. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  14. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  15. Query by meta_key and order by meta_value_num return orderby date
  16. Wp_query order by multiple custom fields?
  17. WordPress altering my custom query, How to fix it?
  18. Order by meta_key in custom post type doesn’t affect the query
  19. How to create/modfiy WP_Query to search in post title OR custom field?
  20. Use meta_query to display events by date in custom field
  21. How to show recent and upcoming birthdays using meta_query
  22. Order Posts by meta value AND published date
  23. Using WP_Query and WP_Meta_Query Outside of WordPress
  24. What format does the meta_query TIME type require?
  25. If two first numbers exist in wp_meta_query value
  26. WP_Query on custom field and order results
  27. WP_Query filter and order by meta ordering by wrong joined table
  28. WP_Query last five posts, simply ordered by meta_value
  29. Tax query clause inside a meta query clause?
  30. What is the random string I am seeing when I use get_query_var?
  31. Optional Meta Query
  32. How do I make a meta_query OR relation work? [closed]
  33. Meta_query on same meta key, with diffrenct values
  34. Can we return all category (not post) with Custom Query Filter? [closed]
  35. Extend product search with meta in WooCommerce
  36. how to make members list directory through wordpress post custom meta key.
  37. Changing sort order for presentation by Jetpack infinite scroll
  38. get posts by meta_key from inside key of post meta
  39. Help optimizing slow WP_Query with meta_query
  40. meta_value_num not ordering all items
  41. Meta Queries – should nesting work after WP 4.1?
  42. Filter and Order by Multiple Custom Meta Values
  43. Meta Query relation “AND” then set array accordingly
  44. 2 weeks ago from meta query meta value
  45. WP_Query with meta_query dosen’t return results
  46. Query with meta_query and tax_query together not working properly
  47. Array as ‘key’ in WP_Query
  48. Is it possible to query a custom field where the value is between two fields?
  49. Filter posts by comparing custom meta value against postdate
  50. How to provide meta_key array to wp_query?
  51. Searching for meta_key returns 0 posts
  52. meta_query fails to compare on values containing apostrophes
  53. How to set up hierarchical relationships without using plugins / meta query
  54. Check if searched number is within the post meta value
  55. Meta query compare for ID’s greater than specific ID
  56. Is it possible to add relation between meta_query and tax_query?
  57. add_query_arg to compare and display events from a certain date
  58. Show single posts date, in a page of posts
  59. WP_Query Class custom field parameters
  60. meta_query where the meta value is not the post title
  61. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  62. Query on meta values and post title
  63. How do i create a custom post query when the meta value is an array?
  64. Custom Meta Query doesn’t work the same on two site
  65. meta_query with meta values as serialize arrays
  66. WP Query – grouping posts by same meta key, adding together values from another key
  67. Woocommerce Get Orders By Meta Value
  68. meta_query is overriding default search
  69. Multiple WP_Query args combinations according to post type
  70. WP_Query multiple value not working
  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. WP_User_Query Orderby Not Working
  75. Unusual high query of user meta data
  76. Very slow query generated getting meta data from posts
  77. WordPress Query optimaization for slow query
  78. Meta query doesn’t remove placeholder escape before query
  79. WP Query Meta Query
  80. Query custom meta value – post view and date meta
  81. What is the best way to reset a search on a meta_key / meta_value?
  82. Slow query when selecting with large meta query or post__in
  83. How can I modify standard search query to include also ACF custom fields values?
  84. Custom WP_query and integrating into theme file
  85. WP_Query – show posts where meta value and user_email match
  86. WP Meta Query at depth 2
  87. Best way to Order Post in Home without a plugin
  88. WP_Query using meta_query with LIKE doesn’t return what it should
  89. Is there any difference between below WP_Query code snippets?
  90. Return a single custom post from multiple meta queries
  91. Sorting: custom query with orderby meta_value_num THEN by title
  92. query post based on comparison
  93. Including ‘cat’ => $cat breaks meta_query
  94. meta_query compare not doing what I want it to do
  95. Query string form $_GET[‘value’] is not working as meta value in wp_query
  96. WP_Query orderby not working on custom post_type
  97. 294 Queries on Mainpage of WordPress
  98. WordPress extremely slow when using get_posts with multiple meta_query relations
  99. Use meta query only 3 or more results?
  100. Use value from meta key array for use in WP_Query

Leave a Comment