https://bz.apache.org/bugzilla/show_bug.cgi?id=58915
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|INVALID |--- --- Comment #4 from [email protected] --- 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: [email protected] For additional commands, e-mail: [email protected]
