Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Oct 2006 @ 16:04:59 GMT


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


Subj:   Re: Performance of Tpump Vs Mload
 
From:   Bagare, Vinay

I believe we need to have optimal packsize setup.

If you try to pack more than what TPUMP could handle, there will be extra overhead on TPUMP to determine the optimal value.

You could only get this by trial and error method.

Or you could set packmaximum and check what TPUMP sets the threshold at.

It is not a good idea to have this feature as each time TPUMP needs to calculate this value for us.

Also SERIALIZE option may also help.


Thanks,

Vinay Bagare
W e l l P o i n t Inc.
Advisor - IM Database Administration



     
  <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