From 0c6d95615195a455b9c4bfc0242a7690f5a881ab Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Wed, 27 Feb 2013 09:55:50 -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') diff --git a/extensions/MyDashboard/lib/Queries.pm b/extensions/MyDashboard/lib/Queries.pm index 47778336f..1dc0ecf5a 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