You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Mangrich, Mark V Mr CTR USA HRC" <ma...@us.army.mil> on 2008/09/19 15:52:39 UTC
Memory Limitations (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Hello,
How do I create and write a large HSSFWorkbook file without running out
of memory. When creating a HSSFWorkbook all the sheets, rows and cells
appear to be stored in memory. After a while, if we don't incrementally
stream portions to disk, will we run out of memory?
Thanks
Classification: UNCLASSIFIED
Caveats: NONE
Re: Memory Limitations (UNCLASSIFIED)
Posted by Nick Burch <ni...@torchbox.com>.
On Fri, 19 Sep 2008, Mangrich, Mark V Mr CTR USA HRC wrote:
> How do I create and write a large HSSFWorkbook file without running out
> of memory. When creating a HSSFWorkbook all the sheets, rows and cells
> appear to be stored in memory. After a while, if we don't incrementally
> stream portions to disk, will we run out of memory?
You need to give your app server more memory, that's the only solution :/
Alas the .xls file format isn't well designed for streaming, as lots of
things reference other bits of the file. So far everyone's always found it
cheaper to buy more memory for their servers than do loads of poi work to
reduce the memory footprint, so no large work to reduce the memory use has
ever been sponsored :(
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org