You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by iamakimmer <ma...@gmail.com> on 2012/05/02 21:50:25 UTC
Question on SXSSF buffer
When creating an excel file that potentially has a few thousand columns (not
rows), would it make sense to set the buffer to just 1?
Workbook wb = new SXSSFWorkbook(1);
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Question-on-SXSSF-buffer-tp5681462.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Question on SXSSF buffer
Posted by Yegor Kozlov <ye...@dinom.ru>.
That depends on how much heap your JVM has. At minimum, your heap
needs to accommodate NxM objects where
N is the number of cells in a row and M is the number of rows kept in
memory (window size you pass in the constructor).
A few thousands cells take quite a bit of memory and if heap is
limited then yes, constructing SXSSFWorkbook with windowSize=1 will
make sense.
Yegor
On Wed, May 2, 2012 at 11:50 PM, iamakimmer <ma...@gmail.com> wrote:
> When creating an excel file that potentially has a few thousand columns (not
> rows), would it make sense to set the buffer to just 1?
>
> Workbook wb = new SXSSFWorkbook(1);
>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/Question-on-SXSSF-buffer-tp5681462.html
> Sent from the POI - Dev mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org