After a discussion of using ActiveRecord for data validation, it became
apparent to me (and others) that ActiveRecord was missing the ability to
iterate over a large set of records without storing the entire set in
memory. Someone in the thread mentioned that ActiveRecord Extensions may
have this ability. Essentially, I want to do a Table.find(:all).each,
however there are quite a lot of records and I'd like to iterate across
them without storing the entire dataset locally (something like a
cursor). Does ActiveRecord::Extensions have this ability? I've looked at
the documentation (what little I could find) and didn't see anything
like this.
-Drew
···
--
Posted via http://www.ruby-forum.com/.
Try ActiveRecord::Enumerable by Michael Schuerig:
ActiveRecord Enumerable | Michael Schürig
It uses a 'paged' find under the covers rather than cursors.
jeremy
···
On 2/12/07, Drew Olson <olsonas@gmail.com> wrote:
After a discussion of using ActiveRecord for data validation, it became
apparent to me (and others) that ActiveRecord was missing the ability to
iterate over a large set of records without storing the entire set in
memory. Someone in the thread mentioned that ActiveRecord Extensions may
have this ability. Essentially, I want to do a Table.find(:all).each,
however there are quite a lot of records and I'd like to iterate across
them without storing the entire dataset locally (something like a
cursor). Does ActiveRecord::Extensions have this ability? I've looked at
the documentation (what little I could find) and didn't see anything
like this.