From 7e546edc8f6666bb4b7dc8bd502251b666bd60c0 Mon Sep 17 00:00:00 2001 From: "bugreport%peshkin.net" <> Date: Tue, 12 Jul 2005 00:34:46 +0000 Subject: Bug 299156: Reduce saniitycheck submitter_id time for large sites Patch by Joel Peshkin r=mkanat, a=justdave --- checksetup.pl | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) (limited to 'checksetup.pl') diff --git a/checksetup.pl b/checksetup.pl index 8b39c3ec2..d0652716f 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3771,8 +3771,6 @@ if ($emptygroupid) { } # 2005-02-12 bugreport@peshkin.net, bug 281787 -$dbh->bz_add_index('attachments', 'attachments_submitter_id_idx', - [qw(submitter_id)]); $dbh->bz_add_index('bugs_activity', 'bugs_activity_who_idx', [qw(who)]); # This lastdiffed change and these default changes are unrelated, @@ -3993,6 +3991,16 @@ AddGroup('editcomponents', 'Can create, destroy, and edit components.'); AddGroup('editkeywords', 'Can create, destroy, and edit keywords.'); AddGroup('admin', 'Administrators'); +# 2005-06-29 bugreport@peshkin.net, bug 299156 +if ($dbh->bz_index_info('attachments', 'attachments_submitter_id_idx') + && (scalar(@{$dbh->bz_index_info('attachments', + 'attachments_submitter_id_idx' + )->{FIELDS}}) < 2) + ) { + $dbh->bz_drop_index('attachments', 'attachments_submitter_id_idx'); +} +$dbh->bz_add_index('attachments', 'attachments_submitter_id_idx', + [qw(submitter_id bug_id)]); if (!GroupDoesExist("editbugs")) { my $id = AddGroup('editbugs', 'Can edit all bug fields.', ".*"); -- cgit v1.2.3-24-g4f1b