[EMAIL PROTECTED] (Perrin Harkins) wrote:
>> I guess that DBI gets all records if you use fetchall_array|hashref
>> and that it is else OK.
>
>No, the behavior that I saw was when fetching a row at a time. Behind the
>scenes, DBI would fetch ALL the rows into RAM and then iterate over them.
>This may have been changed since then. It was a couple of years ago.
It's still true, mysql will fetch all records at once, whether you ask
for them or not. You can control it with mysql_(use|store)_result,
which is documented as a feature so I think it's not going away anytime
soon.
------------------- -------------------
Ken Williams Last Bastion of Euclidity
[EMAIL PROTECTED] The Math Forum
