[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    Re: Out of memory
From:       acoliver () apache ! org
Date:       2004-09-27 15:00:37
Message-ID: 26013464.1096295464979.JavaMail.root () set ! superlinksoftware ! com
[Download RAW message or body]

If anyone ever wants to work on the performance branch I can offer advice
and assistance.  If anyone wants to fund that work, my company can help with
that as well.  I also need people interested in switching stuff to NIO and
memory mapping (which is what would be the complete solution to this
problem).

-Andy
-- 
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?


> From: Danny Mui <danny@muibros.com>
> Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
> Date: Thu, 23 Sep 2004 12:47:57 -0400
> To: POI Users List <poi-user@jakarta.apache.org>
> Cc: karl-heinz.zengerle@sawag.com
> Subject: Re: Out of memory
> 
> isn't performance always a tradeoff between memory and cpu usage? you
> have a huge chunk of data, excel/poi isn't really suited for huge ones.
> 
> i wish there was more time in the day so we could merge the performance
> branch due to the memory savings.
> 
> Pravin Pillai wrote:
>> Hi karl, that does work, but I am actually looking for a better way of doing
>> it programatically, so that I don't have to hold on to this huge data in
>> memory and write it at the end. I cud do a chunk write, close and open the
>> file, then append the next chunk, but I don't want to get into that...that
>> will just make it slower.
>> 
>> -----Original Message-----
>> From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com]
>> Sent: Thursday, September 23, 2004 2:48 AM
>> To: 'POI Users List'
>> Subject: AW: Out of memory
>> 
>> Hi Pillai.
>> 
>> Increase the JavaVM via e.g. -Xmx256m (applicable for Tomcat and Eclipse
>> - there main() specific; on different platforms maybe a bit different).
>> 
>> Regards,    Karl-Heinz.
>> 
>> 
>> -----Ursprüngliche Nachricht-----
>> Von: Pravin Pillai [mailto:Pravin.Pillai@neoforma.com]
>> Gesendet: Mittwoch, 22. September 2004 22:35
>> An: POI Users List
>> Betreff: Out of memory
>> 
>> I am experiencing "out of memory" issue with POI. I am doing an export
>> operation and dealing with huge data. And I think maybe it has got to do with
>> the large number of HSSFCells being created. Right now I do a single
>> workbook.write() at the end of the operation. Is there a way I could do the
>> write in chunks or any other ideas to improve the performance. Has anybody
>> else experienced these issues before.
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>> 
>> 
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org


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


[prev in list] [next in list] [prev in thread] [next in thread]