Both DBD::Pg and DBD::mysql fetch ALL records into memory during an "$sth->execute".
While this behaviour is not reported for DBD::mysql, this can be tested easily.
Only DBD::SQLite seems to do it right.
So it is better to revert to the old behaviour: fetching in small batches.
Both DBD::Pg and DBD::mysql fetch ALL records into memory during an "$sth->execute". While this behaviour is not reported for DBD::mysql, this can be tested easily.
Only DBD::SQLite seems to do it right.
So it is better to revert to the old behaviour: fetching in small batches.