From a58285fd06c8113c45377c655dd43cef6337e815 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Thu, 11 Jan 2007 19:06:07 +0000
Subject: Aktualisierung auf MediaWiki 1.9.0

---
 maintenance/archives/patch-backlinkindexes.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 maintenance/archives/patch-backlinkindexes.sql

(limited to 'maintenance/archives/patch-backlinkindexes.sql')

diff --git a/maintenance/archives/patch-backlinkindexes.sql b/maintenance/archives/patch-backlinkindexes.sql
new file mode 100644
index 00000000..5facd9ea
--- /dev/null
+++ b/maintenance/archives/patch-backlinkindexes.sql
@@ -0,0 +1,19 @@
+-- 
+-- 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,
+   ADD INDEX pl_namespace(pl_namespace, pl_title, pl_from);
+
+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);
-- 
cgit v1.2.2

