poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58915] memory eaters
Date Wed, 27 Jan 2016 12:29:19 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58915

givemejob@ya.ru changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|INVALID                     |---

--- Comment #4 from givemejob@ya.ru ---
POI SXSSF uses SXSSFSheet for excel sheet representation.

SXSSFSheet is wraper for XSSFSheet with 'overrided' createRow method. (support
for row flush capability)

Other methods of SXSSFSheet delegates call to XSSFSheet.

Therefore all information about workbook are stored in memory except rows (cell
value and etc)
For example SXSSFSheet.addMergedRegion add CellRangeAddress object in memory
when CellRangeAddress count not constant value. On big data this produce chart
like "1hour monitoring".

–°all of SXSSFWorkbook.write method marshal java objects (except rows) to
ByteArrays (see MemoryPackagePartOutputStream) therefore it produce memory
consumption jump at the end of SXSSFWorkbook.write call.

If reasoning is correct then in my opinion this is should be pointed into
"Quick Guide".
I did not find the information until not investigate it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message