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:[EMAIL PROTECTED]] 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:[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]>
