diff options
| author | bbaetz%student.usyd.edu.au <> | 2002-04-04 14:21:56 +0200 |
|---|---|---|
| committer | bbaetz%student.usyd.edu.au <> | 2002-04-04 14:21:56 +0200 |
| commit | ad66df6731224f96d51010c5b7da0e020425899f (patch) | |
| tree | 3526fbe860156104feb3f49e849c964cfb1ea150 /buglist.cgi | |
| parent | 99da5c1938127f39a094e84b1d7e80b84be0ea68 (diff) | |
| download | bugzilla-ad66df6731224f96d51010c5b7da0e020425899f.tar.gz bugzilla-ad66df6731224f96d51010c5b7da0e020425899f.tar.xz | |
Bug 127200 - query for cc takes long time
r=mattyt, justdave
Diffstat (limited to 'buglist.cgi')
| -rwxr-xr-x | buglist.cgi | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/buglist.cgi b/buglist.cgi index 5863285cf..e4e4bbb56 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -502,9 +502,12 @@ sub GenerateSQL { }, "^cc," => sub { - push(@supptables, - ("LEFT JOIN cc cc_$chartid ON bugs.bug_id = cc_$chartid.bug_id LEFT JOIN profiles map_cc_$chartid ON cc_$chartid.who = map_cc_$chartid.userid")); - $f = "map_cc_$chartid.login_name"; + push(@supptables, "cc cc_$chartid"); + push(@wherepart, "bugs.bug_id = cc_$chartid.bug_id"); + + push(@supptables, "profiles map_cc_$chartid"); + push(@wherepart, "cc_$chartid.who = map_cc_$chartid.userid"); + $f = "map_cc_$chartid.login_name"; }, "^long_?desc,changedby" => sub { @@ -616,7 +619,7 @@ sub GenerateSQL { my $attachtable = "attachments_$chartid"; my $statustable = "attachstatuses_${chartid}_$statusid"; - + push(@supptables, "attachments $attachtable"); my $join = "LEFT JOIN attachstatuses $statustable ON ". "($attachtable.attach_id = $statustable.attach_id AND " . |