Hello, Objective: To write xlsx file with more than 150,000 records.
Problem: java.lang.OutOfMemoryError: GC overhead limit exceeded Approach 1: Increase HEAP size.This is fine. Approach 2: I am trying another approach to overcome the XSSF performace issue.The basic idea for this approach is to process the large inforation in chunks by creating multiple xlsx files of let say 30,000 records and finally read all thes files and create single xlsx file.Can this be done?Your thoughts on this idea. Reagrds, Mayank -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Approach-to-overcome-Xssf-performance-problem-tp5031686p5031686.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]
