RE: AS/400 JDBC Insert performance

[Allen <tayal01@xxxxxxxxx>]

I don't have a choice with the PreparedStatement type.
 I'm surprised to hear that a prepared statement with
bind variables might be less efficient on SQL Server
than a dynamic statement which would have to be fully
parsed and qualified before execution.

Cheers,
Allen.

--- "Hall, Philip" <phall@xxxxxxxx> wrote:
> 
> > I am using the JT/Open toolkit JDBC driver.  I'm
> using
> > Prepared Statements >\
> 
> Have you compared using non-prepared statements ? I
> know for SQL server it was actually slower using
> prepared statements, than dynamically building the
> SQL in a string buffer for each row.
> 
> Also, bulk loading is the fastest, but only
> SQLServer offers a SQL statement to do it.
> 
> In DB2 you use the db2 command line and the LOAD
> sub-command, Oracle uses the sqlldr command. 
> 
> --phil 
> 
> _______________________________________________
> 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