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

1 files changed, 2 insertions, 2 deletions

diff --git a/buglist.cgi b/buglist.cgi
index b99afefe9..206b968ca 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -241,7 +241,7 @@ sub GenerateSQL {
             push(@wherepart, "$table.bug_id = bugs.bug_id");
             my $ptable = "longdescnames_";
             push(@supptables,
-                 "LEFT JOIN profiles $ptable ON $table.who = $ptable.userid");
+                 "INNER JOIN profiles $ptable ON $table.who = $ptable.userid");
             push(@clist, "$ptable.login_name", $type, $email);
         }
         if (@clist) {
@@ -745,7 +745,7 @@ sub GenerateSQL {
     my $suppstring = "bugs";
     foreach my $str (@supptables) {
         if (!$suppseen{$str}) {
-            if ($str !~ /^LEFT JOIN/i) {
+            if ($str !~ /^(LEFT|INNER) JOIN/i) {
                 $suppstring .= ",";
             }
             $suppstring .= " $str";