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 ]