POI : Performance Optimization

[Sachin Mor <sa...@tcs.com>]

Is there any way to write 65000 rows in EXCEL containing 10 columns.
It gives me OutofMemoryException..
also Note: we have large Number of Concurrent Users doing this.

Any Help appreciated.. 

Regards,
Sachin Bhagwandas Mor
Tata Consultancy Services
Mailto: sachin.mor@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty.   IT Services
                        Business Solutions
                        Outsourcing
____________________________________________
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

Re: POI : Performance Optimization

[Nick Burch <ni...@torchbox.com>]

On Tue, 1 Jul 2008, Sachin Mor wrote:
> Is there any way to write 65000 rows in EXCEL containing 10 columns.
> It gives me OutofMemoryException..

Increase the jvm heap size. The default is too small, and excel isn't the 
most memory efficient file format to write.

The other option is to use something like csv, which is much more 
lightweight

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org