in reply to Re: Retrieving a MySQL query in chunks
in thread Retrieving a MySQL query in chunks

That doesn't really solve the problem. The forked process still ends up loading the entire result set into memory at once. The answer for large queries is to set mysql_use_result.
  • Comment on Re^2: Retrieving a MySQL query in chunks

Replies are listed 'Best First'.
Re^3: Retrieving a MySQL query in chunks
by eriam (Beadle) on Sep 13, 2007 at 06:39 UTC
    Sure it will load the stuff in memory (so yes he may need a lot of it), but the application won't freeze which is also what he was trying to achieve.

    Eriam
[reply]

In Section Seekers of Perl Wisdom