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


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.



  <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: 28 Jun 2020