Changeset 45805

Timestamp:

08/15/2019 07:12:04 AM (5 years ago)

Author:

pento

Message:

Schema: Add an index to wp_options.autoload.

Most sites will be unaffected by this change, but those with a large number of rows in wp_options, only a small number of which have autoload set, will see a significant performance improvement.

Sites with a large number of rows in wp_options, with many of them having autoload set will unfortunately see a performance penalty on top of the already very slow queries they're running, but this should be the minority of cases.

Props DanBUK.
Fixes #24044.

Location:

trunk/src

Files:

• wp-admin/includes/schema.php (modified) (1 diff)
• wp-includes/version.php (modified) (1 diff)

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

@@ -145 +145 @@
     autoload varchar(20) NOT NULL default 'yes',
     PRIMARY KEY  (option_id),
-    UNIQUE KEY option_name (option_name)
+    UNIQUE KEY option_name (option_name),
+    KEY autoload (autoload)
 ) $charset_collate;
 CREATE TABLE $wpdb->postmeta (

trunk/src/wp-includes/version.php

@@ -21 +21 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 45744;
+$wp_db_version = 45805;
 
 /**