I am experiencing quite a few problems with POI, speed, and memory usage lately. Thank you for sharing your work.
I have a question regarding the first optimization that involves removing the empty rows. Is POI creating all the empty rows when you do something like: sheet.createRow(0); sheet.createRow(10); sheet.createRow(20); Or is it your client code that is the culprit? The reason I ask is that I have an issue where POI is using so much memory an OOM exception is thrown. After analyzing the heap dump a majority of that memory is un HSSFCell objects (I have not performed a heap dump after adding your optimizations but I am still experiencing the OOM exception so I suspect there is still an issue). I am wondering if there could be a similar situation with a bunch of empty HSSFCell objects being created. Could you give me any pointers in how I can figure out if a similar situation is occurring but with cells instead of rows? Thanks, ryan -----Original Message----- From: David Medinets [mailto:[EMAIL PROTECTED] Sent: Monday, April 26, 2004 12:25 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: POI Optimizations Hi. I've posted several POI optimizations to my http://www.codebits.com/ website. Please consider them public domain. If they are useful, please feel free to incorporate them into the official codebase. thanks, David Medinets Senior Software Developer WorldWide Retail Exchange 703-234-5216 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
