Changeset 60717

Timestamp:

09/07/2025 08:33:43 PM (2 months ago)

Author:

SergeyBiryukov

Message:

Database: Add type_status_author index for the posts table.

This aims to improve performance of some queries on installations with a large number of posts.

Follow-up to [3678], [3690], [9290], [13576].

Props josephscott, LucasMS, Otto42, flixos90, matt, johnjamesjacoby, siliconforks, mukesh27, jonsurrell, SirLouen, SergeyBiryukov.
Fixes #50161.

Location:

trunk/src

Files:

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

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

@@ -185 +185 @@
     KEY type_status_date (post_type,post_status,post_date,ID),
     KEY post_parent (post_parent),
-    KEY post_author (post_author)
+    KEY post_author (post_author),
+    KEY type_status_author (post_type,post_status,post_author)
 ) $charset_collate;\n";
 

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

@@ -2489 +2489 @@
  * @since 6.9.0
  *
- * @global int $wp_current_db_version The old (current) database version.
+ * @global int  $wp_current_db_version The old (current) database version.
+ * @global wpdb $wpdb                  WordPress database abstraction object.
  */
 function upgrade_690() {
@@ -2503 +2504 @@
         $active_plugins[ $key ] = $new_plugin;
         update_option( 'active_plugins', $active_plugins );
+    }
+
+    if ( $wp_current_db_version < 60716 ) {
+        $wpdb->query( "ALTER TABLE $wpdb->posts ADD INDEX type_status_author (post_type,post_status,post_author)" );
     }
 }

trunk/src/wp-includes/version.php

@@ -24 +24 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 60497;
+$wp_db_version = 60716;
 
 /**