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

Yes, I'm building a CSV file, but thanks to the comments above, I'm thinking of 1) writing my own loop, or 2) using Excel::Template. Funny how we get myopic and miss the forest.

—Brad
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot

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

Replies are listed 'Best First'.
Re^3: Using Tie::IxHash to keep database query keys/values in order by haukex (Archbishop) on Feb 16, 2017 at 13:50 UTC
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	[reply] [d/l] [select]