Re: [RDBO] Paging with Iterators

2007-03-26 Thread John Siracusa
On 3/24/07, Randal L. Schwartz wrote: > > "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

Re: [RDBO] Paging with Iterators

2007-03-24 Thread Randal L. Schwartz
> "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

Re: [RDBO] Paging with Iterators

2007-03-23 Thread rose
On Fri, 23 Mar 2007 [EMAIL PROTECTED] wrote: > my $itr = Bar->get_bars_iterator(); Sorry, this should read my $itr = Bar::Manager->get_bars_iterator(); of course as it refers to the manager class. -- Mike Mike Schilli [EMAIL PROTECTED] > while($itr->next()) { > > won't work be

[RDBO] Paging with Iterators

2007-03-23 Thread rose
I'm using Rose with a fairly large MySQL database and using an iterator like my $itr = Bar->get_bars_iterator(); while($itr->next()) { won't work because by default, an iterator will read in all records from the DB, which won't fit into memory. Using my $itr = Bar->get_bars_iterator