Re: AS/400 JDBC Insert performance

["Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx>]

    Hi Allen,

    There's probably quite a lot that can be done, but from the information
given, the only thing that can be said with certainty is that the native
driver should be faster IF, of course, the application is running on the
'400.  Any particular basis for being "pretty sure" you can double the
speed?

> Is there anything I need to do on the AS/400 to
> improve performance?

    Probably, but we have no information about the data or your application.

> Will changing the isolation
> level of my JDBC connection make any difference?

    Yes.

> Do you Yahoo!?

    No.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO         -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?             http://www.jguru.com/faq/Java400



----- Original Message -----
From: "Allen" <tayal01@xxxxxxxxx>
To: "j400-l" <java400-l@xxxxxxxxxxxx>
Sent: Tuesday, July 08, 2003 10:59 PM
Subject: AS/400 JDBC Insert performance


>
> I need to insert 180,000 rows into an AS/400 table
> within a 4 hour period.  Currently the best I can do
> will come in at 8 hours.  I am pretty sure that I
> should be able to at least double this speed.
>
> I am using the JT/Open toolkit JDBC driver.  I'm using
> Prepared Statements and I'm commiting after each batch
> of 250 rows.  The odd thing is that batching up the
> commits at 250 rows doesn't appear to be any faster
> than single row commits.
>
> Is there anything I need to do on the AS/400 to
> improve performance?  Will changing the isolation
> level of my JDBC connection make any difference?
>
> Thanks,
> Allen.
>
> =====
>
>
> __________________________________
> Do you Yahoo!?