Changeset 60717 for trunk/src/wp-admin/includes/schema.php

Timestamp:

09/07/2025 08:33:43 PM (11 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.

File:

• trunk/src/wp-admin/includes/schema.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";