Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Sep 2009 @ 07:13:36 GMT


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


Subj:   What if we use Fload or Mload for less than 10000 rows
 
From:   prahlad.k.patidar

Hi,

We are using Tpump to load rows from flat file into an empty table.

When no of rows are less than say 2000, the performance of Tpump is satisfactory. But as no of rows increases the performance becomes poor and if the no of rows goes to near 20000, it takes almost 30-40 minutes to load the data.

That's is too long.

Can anyone suggest how to improve Tpump performance.

Or what if we use Mload/Fload and how the performance would be when rows are too less.


Regards

Prahlad



     
  <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: 27 Dec 2016