Subject: | Feature request: selectall_array |
The selectall_* family of methods are useful when a result set is not so large that you have to process it row by row. On today's hardware, that is quite often the case. It may even be faster (fewer database round trips) to slurp all the rows at once rather than request one at a time in Perl code.
Personally I find myself often doing this:
my @rows = @{$dbh->selectall_arrayref($sql)};
or sometimes
foreach (@{$dbh->selectall_arrayref($sql)}) { ... }
It would be handy to have a selectall_array() method which returns an array of rows instead of an arrayref.