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

[Philip Mak]

On Tue, 26 Jun 2001, Michael A Mayo wrote:

> > 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.

What's the efficient way of doing this? $sth->fetchrow_hashref?

-Philip Mak ([EMAIL PROTECTED])