Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 21 Dec 2000 @ 15:19:14 GMT


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


Subj:   Re: Import via ODBC
 
From:   David Wellman

Jiri,

Loading data to Teradata via Access has always been notoriously slow. Basically, Access issues a separate insert for every row it needs to load. Whether you're using Access or another tool, this is not a good way to load data to Teradata. I doubt whether the table being empty initially makes any difference to this processing.

You could check to see if Access has any options to allow multiple connections to a remote dbms, if there are you could try using those.

As an alternative, you could try Bteq/Windows. That will allow you to run with multiple sessions - that's a quick and easy way to speed this up quite a bit.

If that isn't fast enough for your needs, then you're probably looking at one of the normal loading utilities running from your Windows PC.


Regards,

Dave



     
  <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