poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jim Talbut <jtal...@spudsoft.co.uk>
Subject Re: problem running on the mainframe
Date Fri, 14 Jun 2013 07:04:06 GMT
On 12/06/2013 21:35, carl sandburg wrote:
> Has anybody tried running a java program that uses POI on a mainframe in
> batch under UNIX System Services?  We are having a problem creating a
> "large" spreadsheet - about 130k rows - the job goes well for about 30k
> records, then starts swapping out, then dies with "out of memory".
> we've used java/POI many times in the past to create smaller spreadsheets.
> no problem.
> memory is set about as high as it will go:
> IJO="-Xms16m -Xmx1500m"
> any suggestions?
> thanks
POI uses a lot of memory for building XSSF workbooks.
Are you able to use the SXSSF API instead?
In my experience this not only uses less memory, but (presumably as a 
result of using less memory) also goes quite a bit faster.


To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message