diff options
Diffstat (limited to 'www/wiki/maintenance/archives/patch-categorylinksindex.sql')
-rw-r--r-- | www/wiki/maintenance/archives/patch-categorylinksindex.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-categorylinksindex.sql b/www/wiki/maintenance/archives/patch-categorylinksindex.sql new file mode 100644 index 00000000..e2b2c3ac --- /dev/null +++ b/www/wiki/maintenance/archives/patch-categorylinksindex.sql @@ -0,0 +1,11 @@ +-- +-- patch-categorylinksindex.sql +-- +-- Per task T12280 / https://phabricator.wikimedia.org/T12280 +-- +-- Improve enum continuation performance of the what pages belong to a category query +-- + +ALTER TABLE /*$wgDBprefix*/categorylinks + DROP INDEX cl_sortkey, + ADD INDEX cl_sortkey(cl_to, cl_sortkey, cl_from); |