RE: AS/400 JDBC Insert performance

[Allen <tayal01@xxxxxxxxx>]

I am using a single connection for all the work.

Cheers,
Allen.

--- "Bartell, Aaron L. (TC)"
<ALBartell@xxxxxxxxxxxxxx> wrote:
> Are you pooling your connections?
> 
> -----Original Message-----
> From: Allen [mailto:tayal01@xxxxxxxxx]
> Sent: Tuesday, July 08, 2003 9:59 PM
> To: j400-l
> 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!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> _______________________________________________
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> _______________________________________________
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 


=====


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com