My technical opinions (take them for what you will) on this: 1. HSSF 2.0 should not be used to generate spreadsheets of >6mb in length. (mid 3.0 I'll probably say 8mb)
2. Many versions of Excel have great difficulty loading spreadsheets of >4mb in length. (Once we write INDEX/DBCELL records, mid-3.0 I'll probably say 6-8mb) 3. This file format is NOT an efficient transfer format and should not be used as such. There are many technical reasons for this. HSSF 2.0's sweetspot is a sheet of 150k-1mb. You can make performance adjustments by increasing the size of the seed constants at the top of Sheet and Workbook, etc and recompiling. This will seed ArrayLists and other collections with larger numbers (so that garbage collections happens less, and array copies happen less). -Andy On Thu, 2002-10-17 at 09:49, [EMAIL PROTECTED] wrote: > > I'm not sure what part is the biggest bottleneck. I just returned from a > United Way meeting and noticed it was finished. The spreadsheet turned out > to be 14.1MB and it's taking roughly a couple of minutes to download from > our AS/400. (Our AS/400 is actually hosted some 30+ miles away from our > office and our network connection isn't the best.) I actually miscounted > the columns (I didn't window over to the right). It was really a 90 column > table with 11297 rows so I'm looking at writing 1,016,730 cells of data > plust the extra 90 column headers which brings this total to 1,016,820. A > pretty sizable file for a spread sheet yet I still don't think I should > have gotten the results that I got. It took over 5 minutes to create. I'll > try to bench mark the building of the result set and compare this with the > time it takes to loop through all records and write to a spreadsheet. > > Cliff > > > > "Iouri Michtchenko" <[EMAIL PROTECTED]> > 10/17/2002 09:00 AM > > > > > > Please respond to "POI Users List" <[EMAIL PROTECTED]> > > To: "POI Users List" <[EMAIL PROTECTED]> > cc: > > Subject: RE: POI Speed... > > > 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> > > > > > > > > > > -- > 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>
