[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 has-test-   |     Focuses:  multisite,
  info                                           |  performance
-------------------------------------------------+-------------------------

Comment (by rishabhwp):

 == Test Report
 === Description
 This report validates whether the indicated patch works as expected.

 Patch tested: https://github.com/WordPress/wordpress-
 develop/pull/8341.diff

 === 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 137.0.0.0
 - OS: macOS
 - Theme: Twenty Twenty 2.9
 - MU Plugins: None activated
 - Plugins:
   * MS Site Creation Query Tracker 1.0.0
   * Query Monitor 3.18.0
   * Test Reports 1.2.0

 === Actual Results
 1.  ✅ Issue resolved with patch.
 **Observation:**
 Prior to applying the patch: ~550 queries during site creation
 After applying the patch: ~220 queries

 === Supplemental Artifacts
 === Number of queries before patch

 [[Image(https://i.ibb.co/JR5bVfSF/Screenshot-2025-06-23-at-10-19-55-PM.png)]]

 === Number of queries after patch

 [[Image(https://i.ibb.co/FPFhyf8/Screenshot-2025-06-23-at-10-21-15-PM.png)]]

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