| Index: trunk/phase3/maintenance/archives/patch-list.txt |
| — | — | @@ -104,4 +104,8 @@ |
| 105 | 105 | required for changes to OutputPage.php and elsewhere to continue |
| 106 | 106 | working on an older database. |
| 107 | 107 | |
| | 108 | +* 2003-05-23: Index for "Oldest articles" |
| | 109 | +"Oldest articles" needs an index on namespace, redirect and timestamp |
| | 110 | +to be reasonably fast. (patch-oldestindex.sql) |
| | 111 | + |
| 108 | 112 | OutputPage.php User.php maintenance/buildTables.inc maintenance/patch-cache.sql maintenance/patch-list.txt |
| Index: trunk/phase3/maintenance/archives/patch-oldestindex.sql |
| — | — | @@ -0,0 +1,5 @@ |
| | 2 | +-- Add index for "Oldest articles" (Special:Ancientpages) |
| | 3 | +-- 2003-05-23 Erik Moeller <moeller@scireview.de> |
| | 4 | + |
| | 5 | +ALTER TABLE cur |
| | 6 | + ADD KEY namespace_redirect_timestamp(cur_namespace,cur_is_redirect,cur_timestamp); |
| \ No newline at end of file |
| Property changes on: trunk/phase3/maintenance/archives/patch-oldestindex.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 7 | + native |
| Added: svn:keywords |
| 2 | 8 | + Author Date Id Revision |