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.

Jim


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


Mime
View raw message