>>>>> "rose" == rose <[EMAIL PROTECTED]> writes:
rose> I'm using Rose with a fairly large MySQL database and using an
rose> iterator like
rose> my $itr = Bar->get_bars_iterator();
rose> while($itr->next()) {
rose> won't work because by default, an iterator will read in all records from
rose> the DB, which won't fit into memory.
Looking at the code, it appears to call $sth->fetch on every call to ->next.
If you have a smart-enough database, this will stream, just as you wish. If
not, you should wish for a happier time when you can use a proper database. :)
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
