poor performance while exporting data to excel from DB2
Posted
by
Naga
on Programmers
See other posts from Programmers
or by Naga
Published on 2012-08-29T21:19:12Z
Indexed on
2012/08/29
21:50 UTC
Read the original article
Hit count: 214
I am facing a performance issue while exporting data from DB2 to Excel 2003. Well the very first reason is file is about 10+ MB where it goes outofMemory Exception. I am using XLSTransformer and HSSFWorkbook classes to transform my xls file. I also have joins in my query( optional). But user most likely is going to choose these options. When they do so, of course, the data becomes huge and take lot of time and some times goes outOfMemory too.
So Please advice me on this.
© Programmers or respective owner