Your best bet (and fastest) would be to use fetchall_arrayref()
like this
my $sth = $dhh->prepare("select * from my_countries");
$sth->execute();
my $reff_array = $sth->fetchall_arrayref();
then you can use $ref_array anyway you want without going back to the DB.
foreach my $row (@$reff_array )
{
....
}
Like the others said the data in the array will be stale but I do not think
you care to much about that.
The point here to remeber is that DBI result sets forward only reads.
cheers
