fetchall_arrayref() or fetchall_hashref() (quite new) would slurp in all at once.
In reply to Re^3: sql record sets by Flexx in thread sql record sets by Anonymous Monk