Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2004 @ 18:51:19 GMT

  <Prev Next>  

Subj:   FastLoad and MultiLoad from Java and JDBC.
From:   John Pianezze

I have experienced rather slow performance using the JDBC type IV driver for batch inserts.

* Using PreparedStatement (which does not support batching) I get 4 INSERTs per second.

* Using Statement and addBatch() to execute a series of INSERTS, I get about 17 INSERTs per second.

Does that sound right?

(I have defined an identity column as th primary key. does that slow things down a lot?)

I know that I really should use FastLoad or MultiLoad for mass-insertion of data.

Question is: how do I do that from Java with the NCR JDBC driver?

I think I can send a bunch of commands with Statement.executeUpdate() such as:


I haven't tried it yet, but what I really want to know is: how do you do this:

     .IMPORT INFILE myfile.txt

How does it know how to access the file when you execute the load on the database server?

The JDBC documentation talks about using multi-threading to split my load over many sessions.

Can I assume that when I use getConnection() that it gets a different "session" for each connection?

John Pianezze

  <Prev Next>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023