[wp-trac] [WordPress Trac] #44921: User nicename discovery is slow to return

[WordPress Trac]

#44921: User nicename discovery is slow to return
-------------------------------------------------+-------------------------
 Reporter:  spacedmonkey                         |       Owner:  pbearne
     Type:  enhancement                          |      Status:  accepted
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Users                                |     Version:  2.0
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch needs-testing has-unit-    |     Focuses:
  tests needs-refresh                            |  performance
-------------------------------------------------+-------------------------

Comment (by spacedmonkey):

 @peterwilsoncc @flixos90  I reported this issue because I was working on a
 popular site that had open user registration. The code was custom but used
 core functionality to create users. Users would be able to fix their
 username. Many of them that had popular names like John and Peter would
 get a 30+ second response time, as this hit the database and really
 affected performance, even on a WordPress VIP site. The site had around
 400k users, so that query was SLOW.

 With the rise of Woo and other social platforms built on top of WordPress,
 user tables can grow on a site very quickly, not to mention multisite. I
 think this caching is important, as without it, large sites will simply
 start failing to load at all.

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