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

Filed under:
|

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

Related posts about java

Related posts about excel