Speed up WP_query with meta comparing dates

Can you upgrade your hosting? I’ve had a very similar query running on AWS that is fine with 1700 events and meta_query that also had location.

Another option for you (if it’s always the same query i.e. today as your queried date) is to use transients to store the result.

$events_arr = get_transient('events_running_today');

if (!$events_arr) {
    $expiration = 2 * 60 * 60; // time in seconds
    // run your existing query here
    $events_arr = // your query    
    set_transient( 'events_running_today', $events_arr, $expiration );
}
// etc etc

Related Posts:

  1. meta_query with meta values as serialize arrays
  2. Use REGEXP in WP_Query meta_query key
  3. compare meta_query in get_posts arguments
  4. Display products from specific category in shop page
  5. How to Compare Two Meta Fields
  6. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  7. Getting attachments by meta value
  8. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  9. Query by meta_key and order by meta_value_num return orderby date
  10. WP_Query not working as expected for attachments and custom meta_query
  11. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  12. Wp_query order by multiple custom fields?
  13. WordPress altering my custom query, How to fix it?
  14. How to query ‘posts_per_page’ to display a different blog posts index template?
  15. Order by meta_key in custom post type doesn’t affect the query
  16. How to create/modfiy WP_Query to search in post title OR custom field?
  17. Order By Multiple Meta Fields
  18. Advanced WP Query hogs the SQL server
  19. How to get user_id from wordpress database inside ajax function?
  20. Multiple meta queries but arrange by specific meta value order
  21. Order Posts by meta value AND published date
  22. WP_Query with multiple meta fields filter?
  23. How to combine meta_query and post__in in WP_Query
  24. What format does the meta_query TIME type require?
  25. How to orderby meta_value_num with dollar ($) sign
  26. pre_get_posts order by not working
  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. Meta Query Array Error 500
  30. What is the random string I am seeing when I use get_query_var?
  31. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  32. Overwrite YoastSEO meta-tags with another page’s [closed]
  33. Fetch Record based on meta key dates
  34. meta_query in WP_Query value is not accepting array
  35. Changing sort order for presentation by Jetpack infinite scroll
  36. meta_query not working as expected
  37. get posts by meta_key from inside key of post meta
  38. Help optimizing slow WP_Query with meta_query
  39. meta_value_num not ordering all items
  40. Meta Queries – should nesting work after WP 4.1?
  41. Filter and Order by Multiple Custom Meta Values
  42. Meta Query relation “AND” then set array accordingly
  43. 2 weeks ago from meta query meta value
  44. Query with meta_query and tax_query together not working properly
  45. Array as ‘key’ in WP_Query
  46. Is it possible to query a custom field where the value is between two fields?
  47. Filter posts by comparing custom meta value against postdate
  48. How to provide meta_key array to wp_query?
  49. Searching for meta_key returns 0 posts
  50. meta_query fails to compare on values containing apostrophes
  51. How to set up hierarchical relationships without using plugins / meta query
  52. Check if searched number is within the post meta value
  53. Meta query compare for ID’s greater than specific ID
  54. Is it possible to add relation between meta_query and tax_query?
  55. add_query_arg to compare and display events from a certain date
  56. Show single posts date, in a page of posts
  57. Query posts by searching for a string in a meta field
  58. WP_Query Class custom field parameters
  59. WP_Query not returning correct result with meta_query parameter
  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. How to filter on placeholder image
  79. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  80. Meta query doesn’t remove placeholder escape before query
  81. WP Query Meta Query
  82. What is the best way to reset a search on a meta_key / meta_value?
  83. Slow query when selecting with large meta query or post__in
  84. WP Meta Query at depth 2
  85. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  86. meta_query not working with the_content()
  87. Using custom field as ‘orderby’ value causing post grouping by publish date
  88. Is there any difference between below WP_Query code snippets?
  89. Sorting: custom query with orderby meta_value_num THEN by title
  90. meta_query compare not doing what I want it to do
  91. Looking for a way to exclude frontpage and nav menu from query filter
  92. Creating Custom Query
  93. Can’t figure out query logic
  94. WP_Query orderby not working on custom post_type
  95. Get posts by meta value except one post [closed]
  96. WP_Query by meta key not returning any posts
  97. WordPress extremely slow when using get_posts with multiple meta_query relations
  98. Showing Counts on Comment List with Custom Query
  99. Use value from meta key array for use in WP_Query
  100. WordPress – Optimize the Meta Query for 3 meta keys at a time