>>while ( my $rowref = $sth->fetchrow_arrayref ) {
>> $r->print $rowref->[0];
>> # ...more $r->print statements for each field...
>>}
>
>
> Does it do the same thing if you don't print anything? I believe some of the
> DBD's cache the entire result set rather than getting it a chunk at a time.
> Which dbd are you using?
it's been a while since I played with this so I'm taxing my memory a bit,
but oracle supports cursor references which, if memory serves, keep the
result set on the server. does mysql support something similar?
--Geoff
