[CDBI] Re: Trouble with Perl's reverse function

Perrin Harkins perrin at elem.com
Tue Nov 14 23:26:53 GMT 2006


On Tue, 2006-11-14 at 15:17 -0800, Carlos Vicente wrote:
> Not really.  Using an iterator (AFAIK) does not load all the objects in
> memory.

It loads all of their primary keys into memory, but doesn't bless those
into objects until you fetch them from the iterator.  I guess it could
go either way, since there's some overhead in the construct() call.
Maybe a large result list would perform better with the iterator and a
small one (e.g. single result) would be better without it.  You'd have
to bench it to know for sure.

- Perrin




More information about the ClassDBI mailing list