Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 23 Feb 2006 @ 16:27:56 GMT


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


Subj:   Re: ODBC Queries repeated
 
From:   Dempsey, Mike

If you are only loading a few hundred rows (or even a few thousand) you may find it is actually faster to load them using SQLA Import, or a simple CLI based application that issues individual insert statements.

The overheads required by the load utilities are fairly high when loading such small amounts of data.

As was stated earlier, unless you use the load utilities, the only mechanism for inserting data is the standard Insert statement.

You can however use multi-statement requests to send multiple Insert statements as 'packages'. (This is how TPump works)

You can do the same thing with a CLI application or with SQLA Import. However with SQLA each record in the Import file must contain all the data required for the entire query, so if your query contains 2 insert statements each record must contain the fields to be inserted for both rows.

(This may be a good thing if you are inserting data to 2 associated tables, but is unlikely to be the format of your data file when inserting to a single table.)


Mike Dempsey
Teradata Client Tools



     
  <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: 15 Jun 2023