Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 23:35:50 GMT


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


Subj:   Re: Adding Nodes and Performance
 
From:   Stover, Terry

I did pretty rigorous benchmarking on 2 separate upgrades (at prior companies) and found that performance did go up linearly with nodes as advertised.

The most likely culprit for no performance benefit (assuming the reconfiguration wasn't botched)is heavily skewed data in your critical tables (the ones that are driving performance). If all the data is parked on a couple of amps, adding nodes won't necessarily help. As an example, if your PI for a customer's table was sex, either M or F, all the data would hash to 2 amps. It wouldn't matter if you had a 2 node system or a 100 node system, your query performance is gated by the 2 amps that have data (query's not done until the last amp finishes), the other amps are idle.



     
  <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