Thanks for the tip. My prototype seems to use about 15% less memory and runs 77% faster with the performance branch code. FYI, the code is using CSV data to generate a spreadsheet with 17 columns and almost 50000 rows.
I'm curious what optimizations have been made so far and if there are any ideas for more. I saw the note about possibly using 1.4 memory-mapped IO to reduce memory overhead -- I'm very interested in that possibility. Jack -----Original Message----- From: Andrew C. Oliver To: POI Users List Sent: 6/24/2003 3:27 PM Subject: Re: generating spreadsheets and memory utilization I'll be merging performance into the head very soon... When is very soon? As soon as a I have a contiguous block of time to keep it all in my head at once. :-) "cvs co -r performance-branch jakarta-poi" On 6/24/03 3:17 PM, "Danny Mui" <[EMAIL PROTECTED]> wrote: > Cocoon uses the same API at the end of the day. > > We have a performance branch that reduces memory by a good amount > (40%?). Pull it down from CVS and see if the results are better? > > Humphrey, Jack wrote: > >> Hi, >> >> I am writing some code to generate speadsheets and hope to be able to use >> POI. In my prototyping, I ran into the known issue of requiring large >> amounts of memory to generate a large spreadsheet. To generate a 15MB xls, >> it is taking up to 290MB of memory. I am writing a server application and >> that level of memory utilization is not acceptable. >> >> Do I have any alternatives? If I use the Cocoon serializer and write >> Gnumeric XML instead, does it still require as much memory? Any tips? >> >> Thanks. >> >> Jack Humphrey >> >> >> >> --------------------------------------------------------------------- >> 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] > -- 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? --------------------------------------------------------------------- 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]
