Skip Menu |

This queue is for tickets about the DBI CPAN distribution.

Report information
The Basics
Id: 106411
Status: resolved
Priority: 0/
Queue: DBI

People
Owner: Nobody in particular
Requestors: EDAVIS [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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.
Your wish is granted in 3d3fd6c. Thanks!