For result sets that are not too large, selectall_arrayref
(or fetchall_arrayref) is best. There's not much difference in
performance right now, but in a future DBI release fetchall_arrayref
is going to get *much* faster.
Tim.
On Thu, Mar 14, 2002 at 10:18:11PM -0500, Etienne wrote:
> Two ways to do the same thing, I'd like your feedback on them please. It's
> my first experience for an interactive webpage with a DB..
>
> # This method (fetchall):
>
> my $res = $dbh->selectall_arrayref("SELECT right(left(evtDtSt,10),2),
> evtName from events order by evtDtSt");
> for (1..31) # for the 31 days of the month
> { print "$_<br>";
> while ((defined (@{$res})) && (@{$res}[0]->[0] == $_)) # as long as the
> date is the first event of the result's date
> { print "@{$res}[0]->[1]<br>"; # print the event's name
> shift @{$res}; # go to the nest one...
> }
> }
>
> # Or this method (fetchrow):
>
> my $sth = $dbh->prepare("SELECT right(left(evtDtSt,10),2), evtName from
> events order by evtDtSt");
> $sth->execute();
> my $i = 1;
> while (my @event = $sth->fetchrow_array()) # as long as we have events left
> { while ($i<=@event[0]) # prints the date as long as we're not at the first
> event's date
> { print "$i<br>";
> $i++;
> }
> print "@event[1]<br>"; # then we print the event's name
> }
> while ($i<=31) # to finish the month
> { print "$i<br>";
> $i++;
> }
>
> #####
>
> Ok, both methods gives the same result...
> For my calendar, when I include this into the print of the dates, I was able
> to do it with the fetchall, but I dunno if I would be able to get it to work
> ok with the fetchrow..
>
> Anyways, I'd like to know which method you recommend and why.. or if both
> methods are equivalent.
>
> Etienne
>
