Performance issue when writing large data
Closed this issue · 3 comments
darkbaby123 commented
For some reason I need to generate a very large excel file, which has 700 cols and 13,000 rows. On my 4 core server it takes nearly 30 minutes to write file.
Because the file is created at the very end of the process (and is fast), I guess the bottle neck is on generating the XML in memory. But I'm not sure if it's an Elixir performance issue or this library's. I also have several steps to transform the data to %Worksheet{}
(without stream), and it's very fast.
darkbaby123 commented
Is write_to_memory/2
used to generate excel without file writing? I'll try that. BTW can you recommend some ways to do benchmark in Elixir?