Re: Iterators fetch the entire result set into memory

[prev] [thread] [next] [Date index for 2005/01/23]

Brian Doig wrote:

> Is there any
> way to emulate the equivalent of the DBI fetchrow statements with
> Class::DBI?

If you're doing a paging-style app, you could look at 
Class::DBI::Plugin::Pager.  If you need to go through the whole set one 
row at a time, you would probably need to override some things and make 
more substantial changes.

Keep in mind, many databases (MySQL, PostgreSQL) fetch all of the data 
at once rather than one row at a time, regardless of how you call DBI. 
You would have to change parameters or use cursors to avoid that.

- Perrin