Home Page for the TeradataForum
 

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023