Archives of the TeradataForum

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

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

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>>