Archives of the TeradataForum

Message Posted: Wed, 08 Mar 2006 @ 10:20:20 GMT


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

Subj:		Re: Performance of Fastload vs Multiload

From:		Dunweber, Ole

Dieter wrote:

IMHO Phase 3 of a MLoad (Aquisition) is equivalent to a FastLoad into the worktable, it probably *is* a FastLoad, but only the developers know that :-)

You are probably (as always) right, but I have a little problem with this statement with regards to checkpoints.

According to my understanding both utilities uses the concepts of "internal checkpoints" during their respective application phases.

This is not to be confused with checkpoints taken in their respective acquisition phases.

In a 3rd party vendor book it's described that MLoad logs a checkpoint each time a data block is successfully written to its target table.

I can't find this in the manuals - but I reckon this "data block checkpoint" is the same as an "internal checkpoint"?

If so, and if a Mload acquisition phase equals a Fastload Acquisition phase + a Fastload Application phase, then Mload would issue all these internal checkpoints against the work table in the Mload acquisition phase. And this doesn't seem correct with regards to how restarting from an "acquisition-checkpoint" is described?

Ole Dunweber
Coop Nordic


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

Attachments

Library

Quick Reference