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

[Sterin, Ilya]

You can use foreach (0..$#rows)

Ilya

-----Original Message-----
From: Philip Mak
To: Michael A Mayo
Cc: [EMAIL PROTECTED]
Sent: 06/26/2001 10:36 AM
Subject: Re: Shorthand for $dbh->prepare and $sth->execute?

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])