I've been toying with POI for the past couple of months now trying to get a database file conversion program to work on our AS/400 model 820 running V5R1 OS. I've finally managed to squeeze enough time out of my tight schedule to clean up all the bugs and poor programming from my prototype and have moved the final binaries to the AS/400 into what I call my production package. This package includes the latest (1.8.0) development release of POI. I created an RPG program (that's Report Program Generator not Rocket Propelled Grenade) that invokes my Java program using the latest in RPG/Java support technologies. Basically it uses JNI under the covers to invoke the Java program I wrote to do the actual database file conversion. Yesterday I started running some tests and doing some final optimizations to get some good results. It seemed a little slow, so I used native AS/400 optimization technologies (CRTJVAPGM command) to created what is known as a direct exectuable object. This is supposed to be comparable to compiliing to native code though I don't know all of the details. I optimized to level 40 and ran a test this morning. I databse file that has 8 columns and 11,296 rows has been taking the duration of my keying this email + to convert. (I am a slow typer.) This speed is unacceptable. (and it's still running). Is there anything more that can be done? Could this also be related to JDBC which is used to get the data to write to the spreadsheet? I am using the native JDBC driver for DB2.
Cliff -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
