Without more detail, my guess would be that your JVM has 2GB of XML nodes. Nothing is flushed to disk with XSSF until you call Workbook.write, and nothing is cleared until Workbook.close.
If you only need to create a workbook, the SXSSF streaming API is the way to go. On Sep 4, 2016 7:45 PM, "Hongdi Ren" <[email protected]> wrote: > Hi all, > > > > We’re using poi & poi-ooxml 3.14 generating tens of thousands of rows to > be downloaded. > > > > We have a problem that jvm keeps old gc 5 times/min but nothing could be > collected. What’s more, when we looked into the jvmdump, it has 2G > unreachable objects closed related with poi. We have no idea why that can’t > be cleaned out. > > > > It might be better to use the stream api which we would try recently, but > is there any idea why could this happen? > > > > > > Attached detailed information: > > code > > > > And the jvmdump shows > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
