go ahead... be a heretic | |
PerlMonks |
Re: fetchrow and fetchall questionby UnderMine (Friar) |
on Mar 17, 2004 at 12:33 UTC ( [id://337303]=note: print w/replies, xml ) | Need Help?? |
You are probably better off returning a smaller dataset that will return quicker in a fetchall_arrayref, ie. only the primary key, and then fetch slices through that list.
Then loop to fetch 20 rows each time using something like :- Hope it helps UnderMine
In Section
Seekers of Perl Wisdom
|
|