diff options
author | Frédéric Buclin <LpSolit@netscape.net> | 2017-04-19 13:20:03 +0200 |
---|---|---|
committer | Frédéric Buclin <LpSolit@netscape.net> | 2017-04-19 13:20:03 +0200 |
commit | b177f09048eb2da61fe0dae35e46df66d9f34fbb (patch) | |
tree | 36c6c8b36d3b5d350621e92df703faad6a488634 /buglist.cgi | |
parent | cca49fa6bc14bc170a13860455ff11b0e37615a6 (diff) | |
download | bugs-b177f09048eb2da61fe0dae35e46df66d9f34fbb.tar bugs-b177f09048eb2da61fe0dae35e46df66d9f34fbb.tar.gz bugs-b177f09048eb2da61fe0dae35e46df66d9f34fbb.tar.bz2 bugs-b177f09048eb2da61fe0dae35e46df66d9f34fbb.tar.xz bugs-b177f09048eb2da61fe0dae35e46df66d9f34fbb.zip |
Improve the performance of the SQL query when searching for unvisited involved bugs
Diffstat (limited to 'buglist.cgi')
-rwxr-xr-x | buglist.cgi | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/buglist.cgi b/buglist.cgi index 6e5e3d94c..ea6aa6ee5 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -878,10 +878,10 @@ if (@bugidlist) { $dbh->selectcol_arrayref('SELECT bugs.bug_id FROM bugs LEFT JOIN cc - ON cc.bug_id = bugs.bug_id + ON cc.bug_id = bugs.bug_id AND who = ? WHERE (reporter = ? OR assigned_to = ? OR qa_contact = ? OR who = ?) AND ' . $dbh->sql_in('bugs.bug_id', $new_bugs), - undef, ($user->id) x 4); + undef, ($user->id) x 5); %$involved_new_bugs = map { $_ => 1 } @$involved_new_bugs_list; } } |