Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 10 Oct 2004 @ 11:06:38 GMT


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


Subj:   Mload resource efficiency
 
From:   Siddhartha Raghuraj Hattangadi

Hi,

I have some one line questions; kindly reply in elaborate terms if possible with pointers to reference manuals if any.

Is mload faster at the expense of resources such as I/O and CPU time?

Is mload 'nice' to other users(DBC/SQL sessions) of the database?


If the data volumes are huge (about 2% of table data is affected per session) I guess mload should be the choice but since we have about 40 tables we have to have concurrent mloads, in that case would 15 (MAX) concurrent mloads make it possible for other users to have a reasonable latency?


Thanks,

Sid



     
  <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