Re: Shorthand for $dbh->prepare and $sth->execute?

[Michael A Mayo]

----- Original Message -----
From: "Philip Mak" <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 10:30 AM
> Is this reasonably efficient for tables that have thousands of rows? e.g.
>
> $rows = $dbh->selectall_hashref("SELECT ...");
> for my $row (@{$rows}) {
>   do something with $row
> }

You may know this already, but the way you wrote this is particularly
inefficent because it creates a temporary copy of all the data in an array.

                -Mike