Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Jun 2009 @ 11:40:39 GMT


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


Subj:   Re: MLOAD performance problem
 
From:   Ferry, Craig

The things I've seen which will slow mload are as follows.

1: The table is a set table vs multiset.

2: The table has a UPI.

3: The data is unevenly distributed across amps.


According to your description it doesn't sound like any of the above. BUT still worth looking at.

Is the table empty in both tests you are running? If you are loading into an empty table for the fast test, then loading into a table with records in the second, this could impact performance especially in the above scenarios.

Hope this helps.



     
  <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