Archives of the TeradataForum

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

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

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>>