Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


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:

     "BEGIN IMPORT MLOAD TABLES...."

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
Telephia



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