perl hash to CSV using Text::CSV_XS

[perl_war]

I wanted to convert a perl hash to csv.

I realize this is easy using Text::CSV::Slurp but performance is better in Text::CSV_XS .

In Text::CSV::Slurp I would use create(input=>$object) function.

In Text::CSV_XS I would use print ($io, $colref); I would have to go through array of hashes line by line and use the above function.

What would be more computationally efficient?

[kcott]

G'day perl_war,

Welcome to the monastery.

Perl has a builtin module for this task: Benchmark

[runrig]

Do you really need to store an array of hashes in memory? It might be more 'efficient' to process the data record by record as it is read from the source.

And if it's not that many records, then I wouldn't worry much about which is more efficient.

[Tux]

Have you considered DBD::CSV? It uses Text::CSV_XS under the hood (speed), reads all in memory (database tables) and gives you a SQL interface to your data.

If all you need is to get all CSV into memory as quickly as possible, have a look at Text::CSV_XS' getline_all ()