Archives of the TeradataForum

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

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

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