Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Mar 2006 @ 21:02:24 GMT


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


Subj:   Re: MLoad session calculations
 
From:   Victor Sokovin

  Is it better use Session 20 instead of mentioning session 20 4 for large volumes of data load ( 4 million records)  


  sessions 4 for small volumes of data load ( less than 10000 records)  


Not always. Just run a number of tests on your particular system and find your own optimum. I've seen cases when 4 4 was just fine for both 10,000 and 4 million records. This could be an indication that something else is not optimal, though. But if for whatever reason you can't further improve performance by increasing the number of sessions, it is just better to keep that number as low as possible.


Regards,

Victor



     
  <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