Queries take 120+ seconds on my large WordPress site

Best to work with your host on this type of specific issue. In general, when you have slow queries, a few things may help:

  1. Optimize the database – check and see if any tables are bloated compared to others. You may be able to turn off revisions and autosaves, or reduce the number of allowed revisions, to help some. Plugins may also be creating huge tables so determining which tables are huge and finding out why is a good place to start. There are also database optimization plugins available – be sure to back everything up fully, but they can sometimes drastically reduce the db size and give you quite a speed boost.

  2. Optimize your theme – you can either try out a few different themes or use a query analysis plugin to see where the bottlenecks in your theme are. While this doesn’t affect wp-admin directly, if you have heavy traffic and your front end is being bogged down by visitors, this will affect the performance of your whole site, back end included.

  3. Enable better caching and/or better code – if you’re frequently running uncached queries, it’s a big hit to your database. Caching can make everything run a lot faster.

You might also want to look into the REST API as it may be more performant than XML-RPC.

Related Posts:

  1. Query All users that has post
  2. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  3. get last post’s link with SQL query
  4. Return records between two meta datetimes saved as strings
  5. How to optimize posts query in wordpress
  6. Query to fetch custom taxonomy along with post title
  7. Should we trust the post globals?
  8. Optimize post insert and delete for bulk operations?
  9. MySQL Query to Retrieve Category from wp_posts
  10. SQL Query for getting all posts in their latest revised state
  11. How to know if get_posts() failed?
  12. Search & Remove Specific Shortcode From All Posts
  13. Manually delete post from database
  14. Duplicate posts
  15. Looping through posts per category gives same posts for each category
  16. How to show posts rank based on custom field value
  17. How to force update all posts after import
  18. How do I create Comma Separated list of attached image ids?
  19. Most efficient way to list all categories and display a post for each of them?
  20. Change post format using custom field
  21. wp_enqueue_media() slows down my WP site
  22. How can I get all posts data from within a paginated search result?
  23. Query posts from different categories in multisite
  24. Check if post exists
  25. posts_per_page doesnt work
  26. Only display posts after current date
  27. Reset/Reorder posts ID in the MySQL wp_posts table
  28. XML-RPC and post_date
  29. WP_Query Authors OR Categories
  30. Most liked page not displaying posts
  31. wp_insert_post – duration
  32. get query() without post content?
  33. How can I setup a relationship using categories in WordPress?
  34. Exclude the first ‘n’ number of posts of a tag from home page?
  35. Custom order for Mysql array
  36. posts_per_page option limits the number of Gallery items
  37. How to Mysql select a list of posts with meta_values AND all relevant categories?
  38. Remove a shortcode from all WordPress posts
  39. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  40. Dynamically switch template on click
  41. Get all custom post types excepted some…
  42. Get all comments of author’s posts
  43. Counter is skipping post when I still want it visible [closed]
  44. Do not show children of a category
  45. post__in not working with pre_get_posts, but post__not_in does work
  46. How to get all post_parents of a post?
  47. Query posts and filter at query time by value of custom meta
  48. Run query_posts if SESSION is empty?
  49. Delete post revisions only for a single post
  50. How to give classname to post if post has no content?
  51. Database hacked – random posts are modified
  52. How to retrieve certain number of images from a wordpress post?
  53. Restore woocommerce orders
  54. How to convert query sql to shortcode in wordpress?
  55. How do post IDs work in WordPress?
  56. Some doubts about how the loop work (trying debugging it)
  57. How to display only one category in a custom post type?
  58. Adjust the order for returned posts
  59. Trim posts from WP-Query?
  60. query for filtering published posts?
  61. Trying to exclude custom posts based on date, while sorting by custom field
  62. how to add tags to post in the Loop?
  63. Merge get_comments & get_posts into a single query
  64. How to fetch courses in all languages in WordPress?
  65. Mysql update menu_order problem
  66. How to search through “post title” and “tags” using WP_Query?
  67. Need to display a Jan 1st post as the site’s front page on Jan 1st, and Jan 2nd post as front page on Jan 2nd etc
  68. I have two post types in the same query, how can I use CSS to select only one post type?
  69. ‘posts’ table should not store the absolute image path
  70. load post data into mysql
  71. filter posts based on menu_order
  72. Bulk Post update_post_meta
  73. Show 5 posts and than 3 posts offset with pagination
  74. I need some explanation on global $post [duplicate]
  75. Numbering author posts in posts query
  76. How to run select query of post with category and tags?
  77. Querying posts from current category, using a variable as array argument
  78. Query posts from newest category
  79. SQL trigger failes with post_content
  80. wp query custom orderby not custom field
  81. Custom Select Query pagination not working properly
  82. Sort / Filter Queries
  83. Query post category & remove any post id
  84. Converting Posts to Pages
  85. Display the latest post from some selected authors
  86. Ordering posts alphabetically by meta keys and title
  87. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  88. How to change the publishing date of each posts?
  89. Grab next post title in archive page
  90. SQL query to remove first image in all posts
  91. Continuous listing from a custom field
  92. Displaying Results From Custom Taxonomy Query
  93. How to store post rating system data post independent?
  94. Delete junk text from all the post using my sql command
  95. Get first comment link on the post itself
  96. Make division in post_query?
  97. Display one post randomly from category on home page
  98. If meta_key exists then don’t select this post?
  99. I am using the query block and what I want and see on the editor page is not the same with the actual results
  100. Batch Scanning and Deleting Empty WordPress Posts
deneme bonusu veren sitelerbahis casinomakrobetceltabetpinbahispolobetpolobet girişpinbahis girişmakrobet girişpulibet girişmobilbahis girişkolaybet giriş