Play with the window size passed to the constructor of SXSSFWorkbook. new SXSSFWorkbook(1); // in theory it should be the fastest, each row is immediately flushed. new SXSSFWorkbook(100); // default size of the row buffer new SXSSFWorkbook(1000);
Yegor On Mon, Jul 18, 2011 at 5:13 PM, marcesher <[email protected]> wrote: > I gave the latest nightlies a shot, and performance has indeed much improved! > > Using BigGridDemo, I can generate a 300k / 125-col sheet in between 2 and > 2.5 minutes. > > Using the AutoFlush example, I can generate the same dimension file in about > 4.5 minutes. > > Using the second example, but flushing all rows (flush()), I can generate > the same dimension file in about 3.5 minutes. > > So, not quite as fast as the BigGridDemo example, but a heckuva lot easier > to read. > > Thanks for all the work, folks! > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/SXSSF-API-tp4472443p4599448.html > Sent from the POI - User 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]
