Changeset 45910

Timestamp:

08/29/2019 12:41:45 PM (7 years ago)

Author:

flixos90

Message:

Multisite: Improve performance by caching not found lookups for sites and networks.

With this change, the result of a site or network lookup by ID will be cached even if the ID does not exist. When a new site or network is created, the cache for the respective new ID is cleared.

Props mnelson4, nielsdeblaauw.
Fixes #42251.

Location:

trunk

Files:

• src/wp-admin/includes/schema.php (modified) (1 diff)
• src/wp-includes/class-wp-network.php (modified) (3 diffs)
• src/wp-includes/class-wp-site.php (modified) (1 diff)
• src/wp-includes/ms-site.php (modified) (2 diffs)
• tests/phpunit/tests/multisite/network.php (modified) (1 diff)
• tests/phpunit/tests/multisite/site.php (modified) (1 diff)

trunk/src/wp-admin/includes/schema.php

@@ -1160 +1160 @@
         }
 
+        if ( function_exists( 'clean_network_cache' ) ) {
+                clean_network_cache( $network_id );
+        } else {
+                wp_cache_delete( $network_id, 'networks' );
+        }
+
         wp_cache_delete( 'networks_have_paths', 'site-options' );
 

trunk/src/wp-includes/class-wp-network.php

@@ -102 +102 @@
                 $_network = wp_cache_get( $network_id, 'networks' );
 
-                if ( ! $_network ) {
+                if ( false === $_network ) {
                         $_network = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->site} WHERE id = %d LIMIT 1", $network_id ) );
 
                         if ( empty( $_network ) || is_wp_error( $_network ) ) {
-                                return false;
+                                $_network = -1;
                         }
 
                         wp_cache_add( $network_id, $_network, 'networks' );
+                }
+
+                if ( is_numeric( $_network ) ) {
+                        return false;
                 }
 
@@ -232 +236 @@
                 }
 
-                if ( ( defined( 'DOMAIN_CURRENT_SITE' ) && defined( 'PATH_CURRENT_SITE' ) && $this->domain === DOMAIN_CURRENT_SITE && $this->path === PATH_CURRENT_SITE )
-                        || ( defined( 'SITE_ID_CURRENT_SITE' ) && $this->id == SITE_ID_CURRENT_SITE ) ) {
+                if ( ( defined( 'DOMAIN_CURRENT_SITE' ) && defined( 'PATH_CURRENT_SITE' ) && DOMAIN_CURRENT_SITE === $this->domain && PATH_CURRENT_SITE === $this->path )
+                        || ( defined( 'SITE_ID_CURRENT_SITE' ) && SITE_ID_CURRENT_SITE == $this->id ) ) {
                         if ( defined( 'BLOG_ID_CURRENT_SITE' ) ) {
                                 $this->blog_id = (string) BLOG_ID_CURRENT_SITE;
@@ -458 +462 @@
                                 }
                         }
-                        if ( $network->path === '/' ) {
+                        if ( '/' === $network->path ) {
                                 $found = true;
                                 break;

trunk/src/wp-includes/class-wp-site.php

@@ -163 +163 @@
                 $_site = wp_cache_get( $site_id, 'sites' );
 
-                if ( ! $_site ) {
+                if ( false === $_site ) {
                         $_site = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->blogs} WHERE blog_id = %d LIMIT 1", $site_id ) );
 
                         if ( empty( $_site ) || is_wp_error( $_site ) ) {
-                                return false;
+                                $_site = -1;
                         }
 
                         wp_cache_add( $site_id, $_site, 'sites' );
+                }
+
+                if ( is_numeric( $_site ) ) {
+                        return false;
                 }
 

trunk/src/wp-includes/ms-site.php

@@ -70 +70 @@
         }
 
+        clean_blog_cache( $wpdb->insert_id );
+
         $new_site = get_site( $wpdb->insert_id );
 
@@ -75 +77 @@
                 return new WP_Error( 'get_site_error', __( 'Could not retrieve site data.' ) );
         }
-
-        clean_blog_cache( $new_site );
 
         /**

trunk/tests/phpunit/tests/multisite/network.php

@@ -614 +614 @@
                         $this->assertSame( (string) self::$different_site_ids[0], $network->blog_id );
                 }
+
+                /**
+                 * @ticket 42251
+                 */
+                public function test_get_network_not_found_cache() {
+                        global $wpdb;
+
+                        $new_network_id = $this->_get_next_network_id();
+                        $this->assertNull( get_network( $new_network_id ) );
+
+                        $num_queries = $wpdb->num_queries;
+                        $this->assertNull( get_network( $new_network_id ) );
+                        $this->assertSame( $num_queries, $wpdb->num_queries );
+                }
+
+                /**
+                 * @ticket 42251
+                 */
+                public function test_get_network_not_found_cache_clear() {
+                        $new_network_id = $this->_get_next_network_id();
+                        $this->assertNull( get_network( $new_network_id ) );
+
+                        $new_network = $this->factory()->network->create_and_get();
+
+                        // Double-check we got the ID of the new network correct.
+                        $this->assertEquals( $new_network_id, $new_network->id );
+
+                        // Verify that if we fetch the network now, it's no longer false.
+                        $fetched_network = get_network( $new_network_id );
+                        $this->assertInstanceOf( 'WP_Network', $fetched_network );
+                        $this->assertEquals( $new_network_id, $fetched_network->id );
+                }
+
+                /**
+                 * Gets the ID of the site with the highest ID
+                 * @return int
+                 */
+                protected function _get_next_network_id() {
+                        global $wpdb;
+                        //create an extra network, just to make sure we know the ID of the following one
+                        static::factory()->network->create();
+                        return (int) $wpdb->get_var( 'SELECT id FROM ' . $wpdb->site . ' ORDER BY id DESC LIMIT 1' ) + 1;
+                }
         }
 

trunk/tests/phpunit/tests/multisite/site.php

@@ -2385 +2385 @@
 
                 /**
+                 * @ticket 42251
+                 */
+                public function test_get_site_not_found_cache() {
+                        global $wpdb;
+
+                        $new_site_id = $this->_get_next_site_id();
+                        $this->assertNull( get_site( $new_site_id ) );
+
+                        $num_queries = $wpdb->num_queries;
+                        $this->assertNull( get_site( $new_site_id ) );
+                        $this->assertSame( $num_queries, $wpdb->num_queries );
+                }
+
+                /**
+                 * @ticket 42251
+                 */
+                public function test_get_site_not_found_cache_clear() {
+                        $new_site_id = $this->_get_next_site_id();
+                        $this->assertNull( get_site( $new_site_id ) );
+
+                        $new_site = $this->factory()->blog->create_and_get();
+
+                        // Double-check we got the ID of the new site correct.
+                        $this->assertEquals( $new_site_id, $new_site->blog_id );
+
+                        // Verify that if we fetch the site now, it's no longer false.
+                        $fetched_site = get_site( $new_site_id );
+                        $this->assertInstanceOf( 'WP_Site', $fetched_site );
+                        $this->assertEquals( $new_site_id, $fetched_site->blog_id );
+
+                }
+
+                /**
+                 * Gets the ID of the next site that will get inserted
+                 * @return int
+                 */
+                protected function _get_next_site_id() {
+                        global $wpdb;
+                        //create an entry
+                        static::factory()->blog->create();
+                        //get the ID after it
+                        return (int) $wpdb->get_var( 'SELECT blog_id FROM ' . $wpdb->blogs . ' ORDER BY blog_ID DESC LIMIT 1' ) + 1;
+                }
+
+                /**
                  * Capture the $meta value passed to the wpmu_new_blog action and compare it.
                  */