Archives of the TeradataForum
Message Posted: Thu, 21 Dec 2000 @ 15:19:14 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|