Advanced WP Query hogs the SQL server

There are several options:

  • Use some Lucene-based search index and cache your queries there. Power it with lots of RAM so nothing hits your DB after the first query. Use something like…
    • Elasticsearch
    • Solr
    • Sphinx
    • Do not attempt to run Lucene plain … you will find yourself in hell. Nobody does that for a good reason.
  • Rewrite your Query and use a raw query instead of \WP_Query.
  • Split your query into different queries. Cache the result in a key/value storage (db-server).
    • Use Memcached (meh)…
    • or Redis (better, as you can cluster it and it configures better with load balanced installations.)
  • The easiest way out: Write an update script that loops over your 300 objects/estates. 300 is not much. Convert it to a taxonomy. Ease your life in the long run.

Recommendations:

  • Log slow queries.
  • Add monitoring to your stack.
  • Alert yourself when things go off. Fix it, before your client knows. Inform them about what you fixed. Have happy clients for a long time. Find out that CLV is underrated.

Related Posts:

  1. What is an efficient way to query based on post_meta?
  2. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  3. Optional Meta Query
  4. Changing sort order for presentation by Jetpack infinite scroll
  5. WP_Query: apply an SQL function to meta fileld value
  6. WP Query – grouping posts by same meta key, adding together values from another key
  7. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  8. WP_Query with several meta_query-statements and order by meta_value
  9. WP_Query with “post_title LIKE ‘something%'”?
  10. meta_query with meta values as serialize arrays
  11. compare meta_query in get_posts arguments
  12. Display products from specific category in shop page
  13. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  14. Getting attachments by meta value
  15. How to make an activities stream mixing posts and comments?
  16. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  17. Query by meta_key and order by meta_value_num return orderby date
  18. WP_Query not working as expected for attachments and custom meta_query
  19. SQL query equivalent to WP User Query
  20. Wp_query order by multiple custom fields?
  21. WordPress altering my custom query, How to fix it?
  22. How to query ‘posts_per_page’ to display a different blog posts index template?
  23. Order by meta_key in custom post type doesn’t affect the query
  24. How to create/modfiy WP_Query to search in post title OR custom field?
  25. Order By Multiple Meta Fields
  26. Order posts by meta value and Date
  27. Query sticky posts with thumbnails
  28. How to get user_id from wordpress database inside ajax function?
  29. WP_Query with multiple meta fields filter?
  30. How to combine meta_query and post__in in WP_Query
  31. How to orderby meta_value_num with dollar ($) sign
  32. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  33. Single meta_query query using OR instead of AND in request’s WHERE statement
  34. Meta Query Array Error 500
  35. Slow WP_Query for custom post type
  36. Complex WP SQL Query
  37. Why isn’t my `meta_query` array functioning properly?
  38. Overwrite YoastSEO meta-tags with another page’s [closed]
  39. Sorting events by descending date, and ascending time if multiple events on a date
  40. Fetch Record based on meta key dates
  41. Order by meta value (numeric value lower to higher)
  42. WP_Query with different postmeta filter for each categories
  43. meta_query not working as expected
  44. wordpress ajax relationship query
  45. Query posts with “non set” meta value
  46. Ordering a mysql style datetime stamp with meta_query
  47. Debugging wp_query orderby for taxonomy
  48. Wp_query with 2 meta keys and array of meta values
  49. meta_query: check if number exists
  50. Event with multiple dates, display events chronologically
  51. Query where ANDing slug values not working
  52. Display posts with specific value first in query
  53. How to avoid filling up an array each time I run a WP_query?
  54. How to SQL query posts IDs by categories AND authors?
  55. WP Query / Meta Query [duplicate]
  56. Query posts by searching for a string in a meta field
  57. WP_Query with 4 post meta field arguments gives 500 internal server error
  58. Use have_posts() with array of post results retrieved by $wpdb->get_results
  59. Query multiple post types, but different order for each
  60. How to add date_query to meta_query array
  61. Order by the first array within a meta_query
  62. Query ACF relationship field – Comparator IN – Value array
  63. Combine query in WP_User_Query()
  64. Multiple nested meta queries
  65. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  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. How can I modify the query by adding to the existing query?
  69. ElasticPress is (aparently) messing with my search filters
  70. What is the equivalent WP_Query of a SQL Query?
  71. WordPress Query custom ordering by temporary variable
  72. Comparing Meta Field date in WPQuery using Meta_Query?
  73. Get unique post by meta value using wp_query
  74. How to create better WP_Query to look for date time which is anywhere between two meta values?
  75. WP_Query, ACF field and array
  76. Filtering WP_Query based on wp_postmeta keys values
  77. WP Query. Ordering posts by another post types meta
  78. Multiple meta_query not working
  79. compare for multiple meta values for same key in wp_query
  80. datetime picker, timestamps and meta queries
  81. WP_Query with meta_query won’t orderby
  82. meta_query only check if both value are set
  83. Get posts meta_query by repater field
  84. Query 3 meta_key and orderby
  85. What argument does my function need to echo get_results() query results
  86. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  87. meta_query not working with the_content()
  88. Using custom field as ‘orderby’ value causing post grouping by publish date
  89. Get closest event where meta_key field is an array
  90. How to return value from sql and display it
  91. Meta_query weird behaviour
  92. Looking for a way to exclude frontpage and nav menu from query filter
  93. Creating Custom Query
  94. Get posts by meta value except one post [closed]
  95. WP_Query by meta key not returning any posts
  96. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  97. Get posts using multiple values from ACF checkbox as meta query wordpress
  98. Group By query based on Custom Field
  99. Custom query with custom filtering returning incorrect results
  100. WP Query returning all posts when Meta_query is null