search

jandrew / Spreadsheet-XLSX-Reader-LibXML

Read spreadsheet files with xlsx extentions
Other
4 stars 2 forks source link

The current worksheet_instance always caches the full sheet to process the meta data #93

Open jandrew opened 8 years ago

jandrew commented 8 years ago

For large worksheets this can translate to a 15X expansion of the file size into RAM. My early seat of the pants testing indicates that a 160M worksheet can expand into more than 2.5G of RAM.

jandrew commented 8 years ago

There should be a non-caching path to avoid this.

jandrew commented 8 years ago

It turns out this wasn't a caching issue really. Therefore the solution for this bug does not include adding a cache level for the worksheet instance.

jandrew commented 8 years ago

See Spreadsheet::Reader::ExcelXML