in reply to Iterating through DBIx::Class resultset

Just paginate: https://metacpan.org/pod/DBIx::Class::Manual::Cookbook#Paged-results

Use $max_records as your rows value. Then, you can iterate through the pages up to $rs->pager->last_page (code untested).

Three thousand years of beautiful tradition, from Moses to Sandy Koufax, you're god damn right I'm living in the fucking past

Replies are listed 'Best First'.
Re^2: Iterating through DBIx resultset
by PerlSufi (Friar) on Jul 02, 2014 at 17:31 UTC
    Awesome, stonecolddevin, that worked - Thank you. I'm not all that great at DBIx yet -but that cookbook was a better source than the normal docs.
[reply]

      It's a bit of a bear, and the docs are definitely a jungle, but that cookbook is a great starting place. Jump on #dbix-class on irc.perl.org and you'll get a lot of good help figuring out things that aren't immediately intuitive.

      Three thousand years of beautiful tradition, from Moses to Sandy Koufax, you're god damn right I'm living in the fucking past

[reply]
        I just changed it to this instead. Do you think I still need to iterate to last page? : 
        my $max_records = '';

GetOptions("max_records=i" => \$max_records)
    or die ("Error in command line arguments\n");

my @results = My::App::Schema->schema->resultset('MyTable')->search(
     undef,
        {
            page => 1,
            rows => $max_records,
        }
    );

for my $result ( @results ) {
### Processing Domain ID: ($result->id)
      print $result."\n";
}

        [download]
        Also, is irc.perl.org on freenode?
[reply]
[d/l]

In Section Seekers of Perl Wisdom