in reply to Re^2: Using Tie::IxHash to keep database query keys/values in order
in thread Using Tie::IxHash to keep database query keys/values in order

Hi bradcathey,

I'm building a CSV file

If you use selectall_arrayref, that'll pull all the results from the database into memory. I imagine that fetching the results row by row with DBI's fetchrow_arrayref, the return value of which can be fed directly into Text::CSV's print method, would be more efficient.

Regards,
-- Hauke D

In Section Seekers of Perl Wisdom