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. How to query posts based on lat-lng coordinate as post meta?
  2. Set Alias for meta_query arguments in get_posts()
  3. Add indexing to meta_value in wp_postmeta
  4. Is it possible to orderby multiple meta_keys when using meta_value_num?
  5. Custom WP_Query order by post_meta and (author) user_meta
  6. Using custom meta_query with relation not working as expected
  7. Perform query with meta_value date
  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. datetime picker, timestamps and meta queries
  12. How do I create my own nested meta_query using posts_where / posts_join?
  13. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  14. Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
  15. Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
  16. Exclude post on loop by multiple meta key value
  17. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  18. How to get sum of meta_values of a meta_key in wp_query according to conditions
  19. meta_key and meta_value not working together
  20. Order posts by meta value and Date
  21. Query sticky posts with thumbnails
  22. Order WP Query posts by custom order calculated from post meta values
  23. how to speed up a complex wp_query?
  24. Meta query with order by another custom field
  25. How to query for custom field within Gutenberg block from outside of that post? [closed]
  26. Meta Query for specific months
  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. ACF Date Based wp_query
  32. How to do meta_query for attachments?
  33. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  34. Get attachment by meta_key value
  35. Mysql query and order meta value
  36. Why isn’t my `meta_query` array functioning properly?
  37. Overwrite YoastSEO meta-tags with another page’s [closed]
  38. How to orderby multiple meta fields if some fields are empty
  39. meta_query BETWEEN, but the range is stored in the custom field
  40. Suggestions on making this query/code more performant
  41. Is it possible to set specific posts to show first in a query?
  42. Order by meta value (numeric value lower to higher)
  43. Large AND OR query timing out
  44. Order ascending is ignored in meta query?
  45. WP_Query with different postmeta filter for each categories
  46. Slow WP_Query with ‘OR’ on meta_query
  47. database query with more than a couple meta hangs and doesn’t complete
  48. How to filter a query by multiple meta keys and order by other meta keys
  49. Meta Query doesn’t works as espected
  50. Advanced WP_Query with meta_query, orderby?
  51. Issues with search after added meta_query
  52. Sort by presence of thumbnail
  53. Display posts with specific value first in query
  54. it’s possible make a WP_Query with math operations?
  55. Sorting search results with custom dropdown
  56. WP_Query: apply an SQL function to meta fileld value
  57. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  58. How to create dynamic value in WP_Query meta_query
  59. query post by author gender
  60. How do I add an item to the WP admin menu?
  61. Multiple meta query from array
  62. WP_Query with 4 post meta field arguments gives 500 internal server error
  63. Use have_posts() with array of post results retrieved by $wpdb->get_results
  64. What’s missing in this wp_query and meta_query
  65. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  66. Custom meta_query order for Elementor based on post meta key [closed]
  67. What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
  68. ElasticPress is (aparently) messing with my search filters
  69. Meta query ignores multiple values of the key
  70. Multiple meta_query not returning rows
  71. meta_query order by date present -> future then show null
  72. Check for not NULL not working in meta query
  73. Get unique post by meta value using wp_query
  74. Query against multiple locations within single custom post type post
  75. WP_Query, ACF field and array
  76. Order by Date Custom Field
  77. WP Query. Ordering posts by another post types meta
  78. meta_query compare > not working
  79. Complex Meta Query
  80. Meta Query if Values Don’t Exist
  81. Saving custom fields for WP_Query to retrieve
  82. How to show all the associated posts with specific date of data metabox?
  83. Is it possible to search for a string in posts OR postmeta?
  84. Filter posts/pages by user_role array
  85. WP_Query with MetaQuery issue
  86. WP_Query Posts by Metadata from Option Tree
  87. Custom loop – Isolating post meta output depending on current query taxonomy terms
  88. WP_Query with meta_value_num and meta_query not paged correctly
  89. Post Query not working after updating to 4.1
  90. Orderby Meta Value and Query from Meta Query
  91. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  92. Sort posts in dashboard using custom field; also include posts where field isn’t set
  93. Sort Posts with custom meta key by default which is currently set as optional
  94. Why is WP_Query’s meta_query not filtering results?
  95. WP_Query with several meta_query-statements and order by meta_value
  96. meta_query in wp_query not working as expected
  97. How to get all post_id and meta_value using meta_key in wp_postmeta table
  98. WP Query – Show custom posts only if user contain some user meta
  99. How do I subquery with custom meta fields?
  100. Showing Counts on Comment List with Custom Query
error code: 523