[Koha-bugs] [Bug 23685] Exporting report may consume unlimited memory

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23685

--- Comment #7 from David Cook <dcook at prosentient.com.au> ---
Wow looking at OpenOffice::OODoc... it hasn't been updated in over 10 years.
It's amazing that it still works.

Excel::Writer::XLSX has an interesting little write up on the topic of memory
usage (see
https://metacpan.org/pod/Excel::Writer::XLSX#SPEED-AND-MEMORY-USAGE). 

It looks like OpenOffice::OODoc uses Archive::Zip and Archive::Zip doesn't seem
to be able to stream to output...

It looks like Excel::Writer::XLSX manages memory by writing worksheets out as
temporary files (https://metacpan.org/pod/Excel::Writer::XLSX#set_tempdir()). 

Of course Excel::Writer::XLSX still adds every one of those temporary files
into memory when it's saving the workbook, so it would still have a memory
spike.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.