[wp-trac] [WordPress Trac] #45105: wp_list_authors() performance issue. Queries for user data on authors with no posts

[WordPress Trac]

#45105: wp_list_authors() performance issue. Queries for user data on authors with
no posts
--------------------------+-----------------------------
 Reporter:  billerickson  |       Owner:  SergeyBiryukov
     Type:  defect (bug)  |      Status:  reviewing
 Priority:  normal        |   Milestone:  5.2
Component:  Users         |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |     Focuses:  performance
--------------------------+-----------------------------

Comment (by billerickson):

 This issue affects almost every Genesis-based website. The default Genesis
 404 page builds a sitemap listing all posts, pages **and authors**:
 https://gist.github.com/billerickson/858ad34efdea9c75417b4217e33f8c3b
 #file-archive-php-L37

 Any Genesis site with a sufficiently large registered user list (ie:
 membership sites) can be taken down by hitting random 404s since they’re
 uncached in most instances and trigger thousands of queries.

 This patch is an easy win for performance.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/45105#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform