Super slow queries from author archive pages killing my database

If memory serves, the problem is because you are doing a very large query and then running multiple checks across all of them with your max statement.

You might have much better luck breaking it out into two queries so that you can keep the iterative processing to a minimum.

For example, you might:

  • Query the posts that have your wanted author
  • Query the posts that have the appropriate author term attached
  • Combine the results and display them manually.

I don’t have time at the moment to try and come up with a cleaner query … but that query looks a bit processing intensive … and sometimes it really is faster to do two simple queries.

Related Posts:

  1. What is this JavaScript “require”?
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. get_results using wpdb
  4. How can I make a WordPress database portable and url independent?
  5. wpdb->insert multiple record at once
  6. How to migrate a HTTPS WordPress installation to localhost?
  7. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  8. How to monitor server for error establishing a database connection
  9. How to create bulk page and content? [closed]
  10. Default WordPress settings API data sanitization
  11. Fatal error: Call to undefined function dbDelta()
  12. Connect to remote database using Localhost install
  13. remove missing image attachments
  14. Transient RSS feeds in wp_options not removed automatically?
  15. Best way to move live site local
  16. The revisions table in my database is at 70% capacity and growing. What should I do?
  17. WordPress for a very large website
  18. How to ensure data consistency in WordPress
  19. Database location in WordPress
  20. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  21. WP_list_table bulk_action get edit and delete
  22. How to display data from custom table in wordpress database?
  23. How to intercept update_option() before it saves data?
  24. Change SQL get_results to search for posts with custom term in custom taxonomy
  25. wpdb query on custom table not working [closed]
  26. How to diagnose and keep in check encoding issues?
  27. Add search Value to wp_list_table pagination
  28. stdObject stored in database. How does one convert it to usable format?
  29. I have a table I created, how do I make a form for a user to filter the data?
  30. How to fix unchanged URLs in Database after running serialized search and replace script?
  31. wp_redirection_404 table has grown to 7GB
  32. Does WordPress ever need multiple databases?
  33. Why are no posts showing despite my apparently correct DB restoration?
  34. WordPress database error – Error in SQL syntax – I can’t identify any error?
  35. Multiple wp_options tables to share content across installs
  36. Merging two wp_posts tables while avoiding duplicates
  37. Merging two databases without borking it
  38. Is there a smart way to obtain a list of only some selected user meta data?
  39. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  40. Permit Login if table row exists
  41. Make an Items attribute searchable (taxonomy using existing attribute)
  42. How Yoast SEO plugin works with variable %%name%%?
  43. What would Repair and Optimize WordPress Database do?
  44. fastest replacement DB
  45. Connection refused on locahost after importing database?
  46. When to use custom DB tables or add_option?
  47. Have working sql query… trying to adjust it to use $wpdb
  48. Best host for running large mem and processor intensive WordPress sites?
  49. creating new field on mysql
  50. Does WordPress store the username as a primary key in the database?
  51. Strange characters added to the database
  52. WSOD 3.9.1 – Tried Everything so far
  53. Database Update Required – Update from command-line
  54. Can you refresh ONLY the wordpress adminbar and not the whole page?
  55. Sending posts from Python to WordPress
  56. Problem migrating to localhost
  57. SQL query to set posts in bulk based on the post content
  58. Automate WordPress website setup with prefilled data
  59. Custom search query by category id
  60. How do you render posts from outside wordpress?
  61. Image link issues after importing a database backup to my local web server
  62. multiple wordpress installs w/shared user database but separate content databases
  63. Second ezSQL initialization for MSSQL
  64. Fetch a single row from a custom table for to a given ID
  65. Database create or redirect
  66. Updating seperate database when post attachment is changed
  67. add featured image dialog box disappear
  68. Database structure cheatsheet
  69. White Screen in Home Page
  70. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  71. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  72. How to get a list of articles related to a particular category from my other WordPress website?
  73. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  74. Malware in old website – how to migrate?
  75. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  76. error establishing database connection (WAMP + filezilla)
  77. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  78. How do I update a WordPress wp_postmeta meta_value that contains many options
  79. How can I get $wpdb to show MySQL warnings?
  80. About wp database hooks (error establishing connection)
  81. How to display $wpdb->insert_id; value on redirected page
  82. Should I Use only wpdb Class to Write Custom Queries?
  83. Auto populate form fields based on serial input or pull listings from other websites?
  84. How to extract some part of WordPress full source code
  85. Create Tables in WordPress
  86. Error establishing a database connection for some files
  87. Hash user emails in database?
  88. WordPress Failed to Login (DB Error)
  89. Weird characters in title if it contain “ ”
  90. Share WordPress Database
  91. DB access blocked when initializing WP externally
  92. Saving data to database and exporting to excel
  93. Site does not work right, pages not showing up, even for root admin
  94. ERROR: “Table Prefix” must not be empty
  95. One information repeated on multiple locations on one site [closed]
  96. WordPress: Interact with Database Query Data and Login
  97. Showing Error(TAble already exist)
  98. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  99. SQL query to rewrite all media URLs to end with .webp
  100. Many images in wp-content/uploads folder that are not in Media Library
error code: 523