From b203102412d3840536d244bf450cbfb8f0c9c356 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Sun, 25 Jan 2004 22:56:54 +0000 Subject: [PATCH] Add index to recentchanges to optimize Special:Newpages --- maintenance/archives/patch-list.txt | 5 +++++ maintenance/archives/patch-rc-newindex.sql | 9 +++++++++ maintenance/indexes.sql | 3 ++- 3 files changed, 16 insertions(+), 1 deletion(-) create mode 100644 maintenance/archives/patch-rc-newindex.sql diff --git a/maintenance/archives/patch-list.txt b/maintenance/archives/patch-list.txt index d4f0bee13c..982eb1c6c3 100644 --- a/maintenance/archives/patch-list.txt +++ b/maintenance/archives/patch-list.txt @@ -155,3 +155,8 @@ Run patch-indexes.sql. * 2003-11: linkscc table creation patch-linkscc.sql + +* 2004-01-25: recentchanges additional index +Adds an index to recentchanges to optimize Special:Newpages +patch-rc-newindex.sql + diff --git a/maintenance/archives/patch-rc-newindex.sql b/maintenance/archives/patch-rc-newindex.sql new file mode 100644 index 0000000000..5a6897ebf2 --- /dev/null +++ b/maintenance/archives/patch-rc-newindex.sql @@ -0,0 +1,9 @@ +-- +-- patch-rc-newindex.sql +-- Adds an index to recentchanges to optimize Special:Newpages +-- 2004-01-25 +-- + +ALTER TABLE recentchanges + ADD INDEX new_name_timestamp(rc_new,rc_namespace,rc_timestamp); + diff --git a/maintenance/indexes.sql b/maintenance/indexes.sql index 565c2951c2..90155c0639 100644 --- a/maintenance/indexes.sql +++ b/maintenance/indexes.sql @@ -58,7 +58,8 @@ ALTER TABLE searchindex ALTER TABLE recentchanges ADD INDEX rc_timestamp (rc_timestamp), ADD INDEX rc_namespace_title (rc_namespace, rc_title), - ADD INDEX rc_cur_id (rc_cur_id); + ADD INDEX rc_cur_id (rc_cur_id), + ADD INDEX new_name_timestamp(rc_new,rc_namespace,rc_timestamp); ALTER TABLE archive ADD KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`); -- 2.20.1