my @allrows = ();
while (my $row = $sth->fetchrow_arrayref) {
    push @allrows, $row;
}