Okay, lets start from the top: 1. Do you have logging on -- POI's logging facillities are intended only for autopsies? 2. What is your VM memory set at? 3. Are you sure you're not running in swap memory?
For reference, I ran: http://jakarta.apache.org/poi/javadocs/javasrc/org/apache/poi/hssf/dev/HSSF_java.html#HSSF as follows: $ java org.apache.poi.hssf.dev.HSSF ".\test.xls" write Write mode 1762 ms generation time -- It writes 300 rows of 50 cells, styled, etc. This is on a PIII laptop, jdk 1.3.1_02 and ~768mb and a recent nightly build of POI. (Notice this test runs in the default heapsize.) -- Please try this test and let me know your results. -Andy -andy Torbert Brian IT56 wrote: ><CODESNIPIT> >int nextCellNumber = 0; >// Create first row and put some cells in it. Rows are 0 based. >HSSFRow row = sheet.createRow((short)0); > >//Display the header columns >for (int i=0; i<table.getColumnHeaderCodes().length; i++) >{ > txc.getPerfTimer().startTiming("buildCell inner: "); > String[] s = table.getColumnHeaderCodes(); > HSSFCell cell = row.createCell((short)nextCellNumber++); > //set style of cell > cell.setCellStyle(headerStyle); > // load cell > cell.setCellValue(s[i]); > txc.getPerfTimer().endTiming(); >} ></CODESNIPIT> > >I am using poi 1.5.0 and running the code on a Pentium 3 500mhz w512mb RAM. >This is just a testing server our production server will be faster. In the >code snipit above table is an object which holds a row of Header Columns and >then rows of data. Here I have just included the print out of the header >column. The rows are printed out similarly but with a different Cell Style. >I have wrapped the code in the for loop with a timer and ran a test which >included 3 ColumnHeaders. The results were: > >buildCell inner: : 71 milliseconds >buildCell inner: : 90 milliseconds >buildCell inner: : 110 milliseconds > >So to build the first Row in the workbook it took around 270 milliseconds. >if you multiply that by 1000 rows your talking about 4.5 mins. Sure enough >when I throw a count around the whole thing i was seeing about 4 mins. Can >anyone see anything I am doing wrong that would cause this slow down? 90 >milliseconds to build a cell seems high. > >Thanks > >Brian > >-----Original Message----- >From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] >Sent: Monday, June 24, 2002 6:17 PM >To: 'POI Users List' >Subject: RE: Anyone have performance problems? > > >Look here for an idea of how fast I (a/o we) expect things to run: > >http://jakarta.apache.org/poi/tests/junit/ > >If there are special cases that are slower, I'd like to know. Please >submit some unit tests. Perhaps we should start putting performance >constraints on them. (an assert at the bottom that X seconds haven't >passed perhaps based on some temporal adjustment by machine). > >The "reference" machine (in that its the one that generated the results) >is a AMD Athlon T-Bird 900mhz w/512mb -- if you're running something >slower/smaller of course things make take longer, but I think 3-4 >minutes for 4000 cells is probably way out there. I'd like to see some >code. > >-Andy > >On Mon, 2002-06-24 at 17:54, Hoffman, Jason wrote: > > >>Yea, that does seem long. Our biggest problem has been OutOfMemory >> >> >errors, > > >>which were resolved by adding the java commmand line option to increase >> >> >the > > >>heap size. You might try that, yours may be slow because of memory >>constraints? >> >>-----Original Message----- >>From: Torbert Brian IT56 [mailto:[EMAIL PROTECTED]] >>Sent: Monday, June 24, 2002 4:51 PM >>To: 'POI Users List' >>Subject: Anyone have performance problems? >> >> >>Hi - >> I was wondering what the typical time people experience when >>creating a workbook of about 1000 rows and about 4 columns. This is >> >> >taking > > >>around 3-4 mins for us to generate. It seems a little long. Is this >>normal? >> >>Thanks >> >>Brian >> >>-- >>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >>-- >>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >> >> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
