[wp-trac] [WordPress Trac] #38741: Introduce the concept of a large site in order to speed up the Users screen when there are many users

[WordPress Trac]

#38741: Introduce the concept of a large site in order to speed up the Users screen
when there are many users
--------------------------------+------------------------------------------
 Reporter:  johnbillion         |       Owner:
     Type:  enhancement         |      Status:  new
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Users               |     Version:
 Severity:  normal              |  Resolution:
 Keywords:  has-patch needs-    |     Focuses:  administration, performance
  testing                       |
--------------------------------+------------------------------------------

Comment (by tharsheblows):

 There's also an instance in `wp-includes/update.php` so I've updated that
 one too. This makes the count a transient with a max expiration of 12
 hours and takes the query down from about 2.5s to 50.3ms with user table
 of 184k.

 I'm not sure if:
 1. the value should be a transient
 2. the expiration time should be filterable

 Still needs testing and tests.

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