Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2008 @ 11:35:46 GMT

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

Subj:   Re: MLOAD application phase
From:   DWellman


A little more information would be useful.

Of your 45 minutes what is the split between the Acquisition and Application phases ? I'm guessing from the title of your post that the Application phase is the longest.

What is the definition of the target table, specifically in terms of UPI vs. NUPI, any NUSI's ?

How long are the input data rows ?

How long are the target table rows ?

What size Teradata system are you running on ?

What release of Teradata and TTU are you using ?

From a general perspective, NUSI's always cause MLOAD to slow down (although with current releases of the software it's not so noticeable). If the number of hits per data block on the target table are low then the MLOAD will be nearly as slow as standard SQL (e.g. using Bteq)



Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <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: 28 Jun 2020