Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 Mar 2003 @ 20:17:44 GMT

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

Subj:   Re: Max Load Tasks
From:   Roth, David W


There have been studies done that basically determined that at some point, more sessions per utility don't increase throughput signifigantly. I know I've seen slides on this, but can't remember if there is a whitepaper or not.

Anyways, the 16 sessions is used by a lot of sites; I believe it was just a suggestion that appears to work pretty well.

I personally tailor my sessions to the volume, because at some point, it can take longer for the utility to sign on all the sessions, than to actually load the data.

For instance, if you are fastloading only 10,000 records, this most likely can be completed with 4-8 sessions, before all 280 sessions would get connected.

Play around a little and see.



David W. Roth
Teradata Advanced Certified Professional
TERADATA, a Division of NCR

  <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: 28 Jun 2020