Slow speed and high CPU usage for my code. How to improve it?

I have a hunch that meta query of this complexity is going to be crazy. I am not sure what you are trying to do without context described, but most likely there are easier way to organize that.

Related Posts:

  1. Differences Between WP_Query() and get_posts() for Querying Posts?
  2. Should I use Transients with W3 Total Cache APC Caching? [closed]
  3. What is the most efficient way of querying posts based on visits and date for current day?
  4. Is it true $wpdb->get_results is faster than WP_Query in most cases?
  5. Slow SQL_CALC_FOUND_ROWS Query
  6. get_the_title($postID) OR get_the_title()?
  7. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  8. Multiple queries on Home Page – page load/site speed issue
  9. WP_Query Performance Issues with meta_query
  10. Too many posts cause slow load when paginating
  11. WP_Query times out
  12. Improve wp query perfomance on large db
  13. reducing the amount of wp_query calls
  14. Fastest way of counting posts of a custom post type in a specific taxonomy term?
  15. Use more than one query, but prevent duplicates – at scale!
  16. Is it a good idea to improve meta query performance by adding tax query?
  17. Slow page loads due to WordPress Core Query
  18. Display tags with random thumbnail from selection of posts with that tag
  19. Should wp_query automatic meta and term cache priming be used in an enviroment with an object caching
  20. Loop Performance > JSON files vs. WP_Query vs. REST API
  21. How to increase load time of an archive/search page (WP_Query)
  22. use of 10 new WP_Query : loading too slow (with url) [closed]
  23. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  24. What is the best way (regarding performance) to set transients for logged in users?
  25. How to avoid filling up an array each time I run a WP_query?
  26. Performance concerns: index.php vs taxonomy-$taxonomy.php
  27. Which is from this queries is more faster
  28. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  29. Unusual high query of user meta data
  30. update_post_meta performance in a loop woocommerce
  31. update_post_meta performance in a loop woocommerce
  32. WP_Term_Query->get_terms() very slow query for WordPress filter
  33. Showing the correct number of posts_per_page when avoiding the use of post__not_in
  34. Calculating efficiently on large amount of data generated by wp_query
  35. Website goes slow down after importing long database
  36. Optimising amount of calls to custom fields
  37. Post OrderBy slow performance
  38. When should you use WP_Query vs query_posts() vs get_posts()?
  39. When to use WP_query(), query_posts() and pre_get_posts
  40. WP_Query by just the id?
  41. Meta_query compare operator explanation
  42. WP_Query with “post_title LIKE ‘something%'”?
  43. wp query to get child pages of current page
  44. How to get an array of post data from wp_query result?
  45. How to get post id of static front page?
  46. meta_query with meta values as serialize arrays
  47. How to only display posts whose meta_value field is not empty?
  48. Get post ids from WP_Query?
  49. Pagination when using wp_query?
  50. Exclude post ID from wp_query
  51. How to print the excuted sql right after its execution
  52. How to extend WP_Query to include custom table in query?
  53. How to store and receive variables in WP sessions?
  54. Should I use Pre Get Posts or WP_Query
  55. How can i retrieve default post per page value? from settings->reading. And total number of posts?
  56. Nested meta_query with multiple relation keys
  57. Is it necessary to use wp_reset_query() in a WP_Query call?
  58. Can I force WP_Query to return no results?
  59. Can wp_query return posts meta in a single request?
  60. Using pre_get_posts with WP_Query
  61. Find out total number of pages in global query on archive page?
  62. WP_Query + random
  63. Resetting post data to previous loop in nested loops
  64. order by numeric value for meta value
  65. numberposts? showposts? posts_per_page?
  66. $GLOBALS[‘wp_the_query’] vs global $wp_query
  67. Broken? WP_Query and “attachment” as a post type
  68. Some doubts about how the main query and the custom query works in this custom theme?
  69. Order by multiple meta key and meta value [closed]
  70. Post_count only shows the number of results per page
  71. Page template query with WP_Query
  72. meta_query ‘compare’ => ‘IN’ not working
  73. Query posts only with featured image
  74. Wp get all the sub pages of the parent using wp query
  75. What is appropriate flow for custom data from URL in WP_Query?
  76. How to display page content in a page template?
  77. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  78. How to merge two queries together
  79. Posts with at least 3 tags of a list of tags
  80. Get post count of current loop when using multiple queries on one page
  81. why ignore_sticky_posts in sticky post query
  82. Wp_redirect and sending variables
  83. Multiple relationship for multiple tax_query in WP_Query
  84. How do I get posts that have a thumbnail in WP_Query?
  85. Multiple WP_Query loops with Pagination
  86. How do I query for posts by partial meta key?
  87. Pagination with custom SQL query
  88. Return only Count from a wp_query request?
  89. Using a custom WP_Query with get_template_part loop
  90. Use REGEXP in WP_Query meta_query key
  91. Why is the loop not empty on some 404s?
  92. WP_Query orderby post__in remains ineffective in the Loop [closed]
  93. WP Query Args – Title or Meta Value
  94. How to query for most viewed posts and show top 5
  95. WP_Query orderby date not working
  96. WordPress Pagination Not Working – Always Showing First Pages Content
  97. Best way to detect if you are in a SINGLE POST page
  98. Meta query with string starting like pattern
  99. WP Query where title begins with a specific letter
  100. WordPress tax_query “and” operator not functioning as desired

Leave a Comment