http://qs321.pair.com?node_id=1182140


in reply to Re: Using Tie::IxHash to keep database query keys/values in order
in thread 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

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