Archives of the TeradataForum
Message Posted: Tue, 20 Jul 2004 @ 18:51:19 GMT
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?
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023