diff options
author | jake%acutex.net <> | 2001-06-19 11:05:08 +0200 |
---|---|---|
committer | jake%acutex.net <> | 2001-06-19 11:05:08 +0200 |
commit | aa7b4750a7c84e2807cdaa66d304fa42615a6f6e (patch) | |
tree | f072a94d81c6d29c7aaad83f2011e11315f29c54 /checksetup.pl | |
parent | aad3b8b5731596f6cc98c9c9bdda9e3bda463af3 (diff) | |
download | bugzilla-aa7b4750a7c84e2807cdaa66d304fa42615a6f6e.tar.gz bugzilla-aa7b4750a7c84e2807cdaa66d304fa42615a6f6e.tar.xz |
Running a query using the Added Comment option was very slow (bug 57350).
Patch by Myk Melez <myk@mozilla.org> and Dave Miller <justdave@syndicomm.com>
r= jake@acutex.net
Diffstat (limited to 'checksetup.pl')
-rwxr-xr-x | checksetup.pl | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/checksetup.pl b/checksetup.pl index ed90b6f5d..f8ef65d77 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -761,6 +761,7 @@ $table{longdescs} = thetext mediumtext, index(bug_id), + index(who), index(bug_when)'; @@ -2184,6 +2185,16 @@ if (-d 'shadow') { DropField("profiles", "emailnotification"); DropField("profiles", "newemailtech"); +# +# 2001-06-06 justdave@syndicomm.com: +# There was no index on the 'who' column in the long descriptions table. +# This caused queries by who posted comments to take a LONG time. +# http://bugzilla.mozilla.org/show_bug.cgi?id=57350 +if (!defined GetIndexDef('longdescs','who')) { + print "Adding index for who column in longdescs table...\n"; + $dbh->do('ALTER TABLE longdescs ADD INDEX (who)'); +} + # 2001-06-15 kiko@async.com.br - Change bug:version size to avoid # truncates re http://bugzilla.mozilla.org/show_bug.cgi?id=9352 ChangeFieldType('bugs', 'version','varchar(64) not null'); |