Howdy all, Looking simply for any tips when writing huge workbooks using the SXSSFWorkbook implementation. I'm pulling data from a database and writing out a workbook. In this particular case I'm writing upwards of 3+ million rows across 5 sheets. Using the SXSSF implementation (MUCH better than XSSF obviously) I can nearly complete the operation. Memory appears to quickly reach 2GB useage for the process but performance degrades gradually until I get a java.lang.OutOfMemoryError: GC overhead limit exceeded error.
Are there any quick wins I should be looking for? In the latest incarnation of my code (of which there have been many) I am manually flushing 200 rows at a time with the initial workbook constructor instantiated with the -1 (disable auto flushing) flag. I'm thinking maybe just up the Java memory footprint but... was hoping to keep a more compact JVM using SXSSF. Any thoughts? Thanks, -Matt
