The event API runs in under 7MB for up to about a 4mb file. :-) The HEAD can do a 4MB file using the user model in around 32mb.
-- 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? The views expressed in this email are those of the author and are almost definitely not shared by the Apache Software Foundation, its board or its general membership. In fact they probably most definitively disagree with everything espoused in the above email. > From: Michael Zalewski <[EMAIL PROTECTED]> > Reply-To: "POI Users List" <[EMAIL PROTECTED]> > Date: Tue, 23 Dec 2003 00:20:52 -0500 > To: POI Users List <[EMAIL PROTECTED]> > Subject: RE: poi/hssf memory help please > > I didn't know POI would run in 32MB! Wow! <bg> > > -----Original Message----- > From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 23, 2003 12:05 AM > To: POI Users List > Subject: Re: poi/hssf memory help please > > Holy crap it looks like your total heap size is 32MB? Default in Java is > like 64MB. >java -Xmx128m -Xms128m... Would set it to 128mb with a min of > the same. I didn't know WL would run in only 32 mb! Wow! > > -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? > > The views expressed in this email are those of the author and are almost > definitely not shared by the Apache Software Foundation, its board or its > general membership. In fact they probably most definitively disagree with > everything espoused in the above email. > >> From: [EMAIL PROTECTED] >> Reply-To: "POI Users List" <[EMAIL PROTECTED]> >> Date: Mon, 22 Dec 2003 22:47:38 EST >> To: [EMAIL PROTECTED] >> Subject: poi/hssf memory help please >> >> Hello, i am using: >> >> redhat linux enterprise >> weblogic6.1 >> java 1.3.1 >> >> When generating a 1000+ row x 54 col excel sheet using HSSF, the java > servlet >> throws an outofmemory exception everytime (if i do one with 600 rows or > less, >> it works fine). This is the first time i am using hssf and I followed the >> tutorial code: >> >> HSSFRow title = sheet.createRow((short)0); >> title.createCell((short)0).setCellValue("columnname1"); >> title.createCell((short)1).setCellValue("columnname2"); >> ......etc..... >> title.createCell((short)54).setCellValue("columnname53"); >> >> ResultSet rs = getresultset(); >> int rowcount=1; >> rs = executeQuery(sql); //get resultset, leftout some jdbc codes >> while (rs.next()) //has 1000+ rows >> { >> HSSFRow datarow = sheet.createRow((short)rowcount); >> rowcount++; >> for(int colcount=0; colcount<55;colcount++) >> { >> > datarow.createCell((short)colcount).setCellValue(rs.getString(colcount+1)); >> } >> } >> >> Here's memory usage log file from 2 tries, both resulted in outofmemory: >> >> [GC 13773K->10735K(32640K), 0.0287972 secs] >> <Dec 22, 2003 10:04:35 AM EST> <Debug> <DEBUG> <*********************FIRST >> FOR LOOP:0> >> ...... >> <Dec 22, 2003 10:07:04 AM EST> <Debug> <DEBUG> <CELL COUNT:50 CELL > VALUE:0> >> //*****Note this row never finished, cell count should reach 54 like every >> other row. >> [Full GC 32639K->29327K(32640K), 1.8477303 secs] >> [Full GC 29327K->29289K(32640K), 1.8480125 secs] >> <Dec 22, 2003 10:07:08 AM EST> <Error> <HTTP> >> <[WebAppServletContext(2438883,yyy,/yyy)] Servlet failed with Exception >> java.lang.OutOfMemoryError >> <<no stack trace available>> >> >> >> -------------- >> >> >> [GC 11797K->8490K(32640K), 0.0076758 secs] >> [GC 11818K->8461K(32640K), 0.0067751 secs] >> <Dec 22, 2003 10:15:11 AM EST> <Debug> <DEBUG> <*********************FIRST >> FOR LOOP:0> >> ....... >> <Dec 22, 2003 10:17:12 AM EST> <Debug> <DEBUG> <CELL COUNT:54 CELL > VALUE:0> >> [Full GC 30728K->27639K(32640K), 1.7628752 secs] >> [Full GC 32457K->28945K(32640K), 2.1956773 secs] >> [Full GC 28945K->28945K(32640K), 1.7103354 secs] >> <Dec 22, 2003 10:17:19 AM EST> <Error> <HTTP> >> <[WebAppServletContext(2438883,yyy,/yyy)] Servlet failed with Exception >> java.lang.OutOfMemoryError >> <<no stack trace available>> >> >> >> From the log it seems the machine is not out of memory? I am really not > sure >> what is going on with hssf now. Please help, thank you >> >> gaga >> > > > --------------------------------------------------------------------- > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
