Here is the minimum amount of information I need in order to be of any help at all (not out of will but out of ability).
1. The simplest, smallest amount of code which reproduces the problem (rip out the JDBC and stick in dummy data, and try it). 2. The simplest input spreadsheets (if any) that reproduce the problem. 3. The simplest output spreadsheets (if any) that reproduce the problem. Without these I can only: 1. Relay personal experience 2. Point you to the unit tests which do similar things and run in far less time. (we have like 300 unit tests, some of which do really really big things, and all of them have completed (on a 900 mhz athlon) in under 4 minutes. Or the results all happen in under 146.604 seconds on an HP LC2000 (733mhz PIII) (those are the results here: http://jakarta.apache.org/poi/tests/junit/ of particular interest is this test: http://cvs.apache.org/viewcvs.cgi/*checkout*/jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel/TestWorkbook.java?rev=HEAD&content-type=text/plain see "testManyRows" -- it completes in about 15 seconds on the PIII) When SOA Workbook comes out or POI 3.0 starts development we'll be reducing POI's memory consumption by 75% and performance will increase by a factor of about 2. -Andy On Thu, 2002-10-17 at 09:00, Iouri Michtchenko wrote: > Are you sure that the POI part is the reason? > Why not to put some debug output??? > I use POI for almost the same kind of things and I don't have any problems > with performance. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:Clifton.Craig@;rrd.com] > Sent: Thursday, October 17, 2002 3:03 PM > To: POI Users List > Subject: Re: POI Speed... > > > > It's still running! Also note that my program is basically creating a JDBC > result set from a SQL statement and writing this data column by column row > by row to the spreadsheet. Nothing fancy. It's still running! > > Cliff > > > > -- > To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> > > > > -- > To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org> > -- http://www.superlinksoftware.com - software solutions for business http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in Java http://krysalis.sourceforge.net/centipede - the best build/project structure a guy/gal could have! - Make Ant simple on complex Projects! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
