Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re: fetch row or fetchallby steves (Curate) |
on Nov 09, 2004 at 20:46 UTC ( [id://406493]=note: print w/replies, xml ) | Need Help?? |
You can still count the rows and only use the first 100: your loop could keep the first 100 but continue counting until fetching is complete. It's about the same as fetching all of them using a DBI fetchall call, but fetching would probably (but not necessarily depending on the underlying database driver) use more memory in your application.
In Section
Seekers of Perl Wisdom
|
|