Re: AS/400 JDBC Insert performance

[Allen <tayal01@xxxxxxxxx>]

Joe,

--- Joe Sam Shirah <jshirah@xxxxxxxxxxxxx> wrote:
> 
>     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?

I truly believe that I should be seeing a noticeable
performance benefit from batching my commits.

> 
> > 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.
> 

What sort of information would you like?

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

So what is the best for an INSERT scenario?

> > Do you Yahoo!?
> 
>     No.
> 

Sorry no control over this.  :-)

> 
>                                                     
>     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!?
> 
> 
> _______________________________________________
> 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