FOREX.com Live Market Information

Real Time Forex Prices

Happy Christmas

JExcel / POI (API for Excel Writing)

In JExcel, we are Writing Cell by Cell. Excel Writing will start, (JDBC) after While(rs.next()) loop. JExcel will take more HEAP Memory. For Example , You are taking 2 1/2 Lakshs Records from resultset, then JExcel will place this records in HEAP Memory during cell by Cell Writing. Whenever this loop is Completed after that only it will create Excel File in Client Side. I checked another Pakage POI API from Apache Software.  This API also doing the Same Logic.

 We can Achive Sheet by Sheet Excel Writing.But, We are Keeping Large Amount of DATA in HEAP Memory. It will Surely affect Websphere Server Performance.

My Best Solution is for Excel Writing is... Write 60,000 Records in One Excel File. Remaining Write in another File. One Important Thing is, Download Sholud be always Client Side. Please Don't Keep Much Data in Server Side. It will affect Server Performance. Use out.print() Function and it is Fast. Because, We are start writing the Excel File in Client Side inside the While(rs.next()) Loop. We are not keeping any Records in HEAP Memory. We are directly writing Excel File using out.print (OutputStream).