Very slow query

To check if the query itself is slow or anything else slows it down, try running your query directly in the database, and have a look at how long it takes there.

<?php echo $GLOBALS['wp_query']->request; ?>

This shows you the latest Query that WordPress ran in your database.

If the query is really slow in the database, try caching the results, running this specific quer only once every hour or so. I usually do this with menus – but it works with anything. Using transients to save the output HTML.

I wrote about this technique here.

If you need different output for different taxonomies, try adding the TermID in the name of the transient.

You could delete the transients either on ‘update_post’ or let them expire after a certain time.

Related Posts:

  1. Is there any difference between hooks posts_where with posts_join and posts_search performance wise?
  2. What is the most efficient way of implementing a favorite post system?
  3. Advanced Custom Fields – Query Efficiency
  4. Does meta_query work within get_posts array?
  5. Mysql / WordPress killing my server with 80k users [closed]
  6. How to show more than 5 posts?
  7. How to optimize my query filtering out unwanted data?
  8. Remove posts from query for events whose start date has passed
  9. get_posts() loop returns the same the_title() for each post
  10. List all posts from past week grouped by sub-category
  11. Order posts by custom field DATE value
  12. Why a URL with a query is always slower than that without a query?
  13. How do I see the mysql query generated by get_posts( $args )?
  14. Create Indexes for Slow Queries
  15. get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
  16. pre saved posts query from db options table
  17. wp_posts query slowing down my website
  18. Re-sort get_posts query results
  19. Can I include get_posts in this array?
  20. Improve performance of slow query
  21. How can I get posts by 2 meta keys, prioritising one of them?
  22. Category_in return empty
  23. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  24. Sort order in get_posts [closed]
  25. Custom query_var causes displaying posts archive on front page
  26. Why does get_the_time(‘F j’) return November 30 for all posts?
  27. Query by one meta_key and sort by another (possibly NULL value)
  28. Search Terms – Querying on either description__like OR name__like in the same Term Query?
  29. I have over 4000 posts, will querying some of them cause performance issues?
  30. Count user posts by user ID, Post type and Post status
  31. Can’t pass table to $wpdb->prepare
  32. How to get category link without a database query
  33. search through post-type attachments titles
  34. Date query year and month OR just year
  35. cron job to auto delete posts of a specific post type older than x days
  36. WP_query category__in not working, only pulls from first category
  37. Most effective use of DB querys
  38. mysql query paging
  39. Two differents queries in archive page
  40. How do I find if a page has a template?
  41. How to set back query var author_name after unset it?
  42. My SQL function to change user_name
  43. How select a specific query when setting offset?
  44. How to retrieve elements from another table in a SQL query?
  45. WordPress Loop: List All Posts by a Category & Subcategory
  46. Order query by post meta value
  47. Query Custom Post Type posts by Keyword/url slug
  48. how would I create a custom query to get all users, and a related post based on a postmeta field?
  49. Display posts with a start OR end date later than current date
  50. Form redirect with query vars to page
  51. Query to Get All Users from wp_users With NO matching user_id In wp_usermeta
  52. WordPress custom setting page – add flashing message
  53. Custom query AFTER rss fetch_feed not working
  54. Check return value of get_posts
  55. Multiple Category Query
  56. list all categories that have a certain word in title
  57. Passing parameters to a static front page
  58. wp_list_pages() refuses to output posts
  59. Can’t seem to do combined query AND sort?
  60. Custom query for custom post_type
  61. sort query results by newest
  62. How to reset usual $query on search page to push custom $wpdb query there?
  63. Order by meta value pro first then meta value free in my search function
  64. Why posts array is empty?
  65. Order posts by date, but also give priority for a specific term
  66. How to delete all posts, categories and tags from WordPress database
  67. Ideas how to search & replace post_content when string contains a newline?
  68. Query the WordPress database to get data together with replaced information
  69. $wpdb->prepare affecting the query?
  70. WordPress SQL search, how to handle SQL Injection?
  71. Query for Custom Post Type UI Does Not Loop All the Post
  72. Updating with $qpdb->query() always returns 0 rows affected
  73. Wrap/close ‘query’ for a first-letter ordered listing of posts
  74. How to manage a particular “order by” for get_search_query()?
  75. Query to view scheduled or draft post
  76. How to add a Variable to post query
  77. get products by custom date variable
  78. Sort a list of a CPT ( job) if a meta is empty
  79. Check if almost 10 year old – working code is up to date
  80. How to sort by two meta keys in admin area?
  81. wp query multiple values > display a specific value first
  82. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  83. Nested select statements not working
  84. Restore WordPress Backup Locally?
  85. Trouble migrating custom post types from non-wordpress cms
  86. “order” does not affect order of custom query
  87. Create a new post on a specified publish date via link?
  88. Exclude Posts from a Widget
  89. New custom post type entries are not sorted correctly in admin using pre_get_posts
  90. Query String for the WP_QUERY parameters
  91. $wpdb query for price in custom field value
  92. Multiple terms not working on taxonomy
  93. Sorting of coupons in the right way
  94. excludeCat function reverses order of blog posts
  95. Run search query again without pagination gives no results?
  96. Get multiple posts with some custom fields efficient
  97. WP_Query orderby meta key/value suddely stopped working
  98. Where can I find the SQL to get the most used information by wordpress database?
  99. WooCommerce Total # orders [closed]
  100. How to show sticky posts on all pages of the pagination, not just the first page?

Leave a Comment