[wp-trac] [WordPress Trac] #37687: Multisite - Enormous number of update queries during site creation (user roles)

[WordPress Trac]

#37687: Multisite - Enormous number of update queries during site creation (user
roles)
-------------------------------------------------+-------------------------
 Reporter:  fliespl                              |       Owner:  (none)
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Networks and Sites                   |     Version:
 Severity:  normal                               |  Resolution:
 Keywords:  good-first-bug has-patch needs-      |     Focuses:  multisite,
  test-info                                      |  performance
-------------------------------------------------+-------------------------
Changes (by SirLouen):

 * keywords:  good-first-bug needs-testing has-patch => good-first-bug has-
     patch needs-test-info


Comment:

 == Bug Reproduction Report
 === Description
 ❌ This report can't validate that the issue can be reproduced.

 === Environment
 - WordPress: 6.9-alpha-60093-src
 - PHP: 8.2.28
 - Server: nginx/1.27.5
 - Database: mysqli (Server: 8.4.5 / Client: mysqlnd 8.2.28)
 - Browser: Chrome 136.0.0.0
 - OS: Windows 10/11
 - Theme: Twenty Thirteen 4.4
 - MU Plugins: None activated
 - Plugins:
   * Query Monitor 3.17.2
   * Test Reports 1.2.0

 === Bug Reproduction Steps
 1. Activate Multisite
 2. Install Query Monitor Plugin
 3. Go to Network Sites `/wp-admin/network/sites.php`
 4. Open Query Monitor and `Add Site`
 5. ❌ I can't really see a significant number of queries after creation of
 a new Site in the multisite setup.

 === Additional Comments
 Although the problem seems legit, I can't seem to reproduce it
 @fliespl @sainathpoojary @ocean90 can any of you provide with some Testing
 Instructions or see what I'm doing wrong to reproduce this issue?
 Since this issue was mentioned 9 years ago, maybe it has been already
 sorted by other means?

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