Can I end a transaction as soon as I call execute()? or do I have to wait
until I finish fetching all the rows?
For example, I have:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
$dbh->do("start transaction");
my $groups_query = $dbh->prepare(qq{select id, name from staff_grp});
$groups_query->execute;
# place1
while (my @one_group = $groups_query->fetchrow_array)
{
print @one_group;
}
#place 2
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Can I end the transaction in #place1 or do I have to wait until #place2?
Thread Next