From 9f21f1ab5e2b70da18459ef26c14a2372bc0eb76 Mon Sep 17 00:00:00 2001 From: Andreas Fischer Date: Mon, 8 Jun 2009 12:36:26 +0000 Subject: Fix bug #44665 - Add index on log_time to the log table to prevent slowdown on boards with many log entries. Authorised by: acydburn git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9564 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/database_update.php | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'phpBB/install/database_update.php') diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index a77896c470..171a8f1fc6 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -678,8 +678,14 @@ function database_update_info() // No changes from 3.0.5-RC1 to 3.0.5 '3.0.5-RC1' => array(), - // No changes from 3.0.5 - '3.0.5' => array(), + // Changes from 3.0.5 + '3.0.5' => array( + 'add_index' => array( + LOG_TABLE => array( + 'log_time' => array('log_time'), + ), + ), + ), ); } -- cgit v1.2.1