Ref: POI Memory If you are using the usermodel API then the entire data is first loaded onto the memory. We did some tests, and found out that your program may throw out of memory exception for large files, for which we have to explicitly increase the JVM heap size using Command line options while running the program. The same when done using the eventmodel API that streams the data instead of loading it first onto the memory, was more than 10 times faster, occupied lesser memory by 10 times or more. However the ease with which we can go back and forth, or to a specific location in and excel sheet using the usermodel API is not possible with the event one and we have to do the extra coding for that.
Rommel. ----- Original Message ----- From: "pengbo" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]> Sent: Monday, December 08, 2003 1:20 PM Subject: Memory limits > Hi , all > > I have a question concerning the POI memory. Say, I have 1, 000 rows to load > by HSSF, Is it possible? > > Thanks > > Pengbo > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > ************************************************************** > Scanned by eScan Content-Security and Anti-Virus Software. > Visit http://www.mwti.net for more info on eScan and MailScan. > ************************************************************** > > ************************************************************** Scanned by eScan Content-Security and Anti-Virus Software. Visit http://www.mwti.net for more info on eScan and MailScan. ************************************************************** ********************************************************* Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. ********************************************************* Visit us at http://www.mahindrabt.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
