From 5ccff95a61b0c0816fa42da061c298f794daf33d Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Tue, 26 Feb 2013 15:57:37 -0500 Subject: Bug 836067 - backport bug 819432 to BMO 4.2 to improve search performance --- extensions/MyDashboard/lib/Queries.pm | 7 ++----- 1 file changed, 2 insertions(+), 5 deletions(-) (limited to 'extensions/MyDashboard/lib/Queries.pm') diff --git a/extensions/MyDashboard/lib/Queries.pm b/extensions/MyDashboard/lib/Queries.pm index e81e7f73f..2ec4c8a74 100644 --- a/extensions/MyDashboard/lib/Queries.pm +++ b/extensions/MyDashboard/lib/Queries.pm @@ -145,13 +145,10 @@ sub query_bugs { params => scalar $params->Vars, order => [ QUERY_ORDER ]); - my $query = $search->sql(); - my $sth = $dbh->prepare($query); - $sth->execute(); - my $rows = $sth->fetchall_arrayref(); + my $data = $search->data; my @bugs; - foreach my $row (@$rows) { + foreach my $row (@$data) { my $bug = {}; foreach my $column (SELECT_COLUMNS) { $bug->{$column} = shift @$row; -- cgit v1.2.3-24-g4f1b