diff options
Diffstat (limited to 'maintenance/archives/patch-backlinkindexes.sql')
-rw-r--r-- | maintenance/archives/patch-backlinkindexes.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/maintenance/archives/patch-backlinkindexes.sql b/maintenance/archives/patch-backlinkindexes.sql index 5facd9ea..22cc5871 100644 --- a/maintenance/archives/patch-backlinkindexes.sql +++ b/maintenance/archives/patch-backlinkindexes.sql @@ -1,10 +1,10 @@ --- +-- -- patch-backlinkindexes.sql --- +-- -- Per bug 6440 / http://bugzilla.wikimedia.org/show_bug.cgi?id=6440 -- -- Improve performance of the "what links here"-type queries --- +-- ALTER TABLE /*$wgDBprefix*/pagelinks DROP INDEX pl_namespace, @@ -13,7 +13,7 @@ ALTER TABLE /*$wgDBprefix*/pagelinks ALTER TABLE /*$wgDBprefix*/templatelinks DROP INDEX tl_namespace, ADD INDEX tl_namespace(tl_namespace, tl_title, tl_from); - + ALTER TABLE /*$wgDBprefix*/imagelinks DROP INDEX il_to, ADD INDEX il_to(il_to, il_from); |