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 <[email protected]> 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: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
