From e659b228c0614b7c001acb42563d1f8014c5a669 Mon Sep 17 00:00:00 2001 From: Erik Moeller Date: Fri, 23 May 2003 06:15:13 +0000 Subject: [PATCH] Patch for speeding up "Oldest articles" special page. --- maintenance/archives/patch-list.txt | 4 ++++ maintenance/archives/patch-oldestindex.sql | 5 +++++ 2 files changed, 9 insertions(+) create mode 100644 maintenance/archives/patch-oldestindex.sql diff --git a/maintenance/archives/patch-list.txt b/maintenance/archives/patch-list.txt index b660a5bcfe..a5f18540da 100644 --- a/maintenance/archives/patch-list.txt +++ b/maintenance/archives/patch-list.txt @@ -104,4 +104,8 @@ Run patch-cache.sql on the database to set these fields up. This is required for changes to OutputPage.php and elsewhere to continue working on an older database. +* 2003-05-23: Index for "Oldest articles" +"Oldest articles" needs an index on namespace, redirect and timestamp +to be reasonably fast. (patch-oldestindex.sql) + OutputPage.php User.php maintenance/buildTables.inc maintenance/patch-cache.sql maintenance/patch-list.txt diff --git a/maintenance/archives/patch-oldestindex.sql b/maintenance/archives/patch-oldestindex.sql new file mode 100644 index 0000000000..83aa694331 --- /dev/null +++ b/maintenance/archives/patch-oldestindex.sql @@ -0,0 +1,5 @@ +-- Add index for "Oldest articles" (Special:Ancientpages) +-- 2003-05-23 Erik Moeller + +ALTER TABLE cur + ADD KEY namespace_redirect_timestamp(cur_namespace,cur_is_redirect,cur_timestamp); \ No newline at end of file -- 2.20.1