I am trying to write 20000 records in an excel sheet using Apache POI. When i try to do this the process is taking more than 7 minutes. Sometimes i even get the java.lang.OutOfMemoryError. my code simply writes the data retrieved from the database to the excel sheet.
I dint understand the problem in the code. is anything going wrong? Thanks in advance.
[ November 25, 2008: Message edited by: Srikanth Kumar ] [ November 27, 2008: Message edited by: Martijn Verburg ]
SCJP 5, SCWCD 5, SCDJWS 5
posted 8 years ago
POI is known to need a lot of memory (the reason for that is most likely the OLE document format, which is quite complex). Can you allocate a larger heap size to the JVM?