Archives of the TeradataForum

Message Posted: Thu, 02 Mar 2006 @ 13:53:28 GMT

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

Has anyone ever benchmarked the time to perform a Fastload vs a Multiload under the circumstances below?

Assume that in both cases the table is "Fastload Ready" -- aka no secondary indices.

The following two cases:

1) 1 million rows (width - 150 bytes)

2) 1 billion rows (width = 150 bytes)

I am thinking that the load time would not differ by more than 5% of the CPU time for the two cases with Fastload being faster.

If the time difference is not significant, why bother to use Fastload? Just use Multiload in all cases (with or without indices).

I look forward to your responses.

Rgrds,

Bill Gregg
Teradata DBA

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