Archives of the TeradataForum
Message Posted: Fri, 12 Jan 2001 @ 10:23:37 GMT
I'm not certain you'll get any really sensible answers for this. As you say there is more than just cpu power, it will also be affected by number of nodes, disk config, memory, virtual configuration, channel/lan connects and (last but not least) the work load that your running. It is probably this last factor which provides the most cause of variation. If you have a heavy disk i/o workload then the difference in Node cpu power is less important. Having said that, for a 4700 to 4800 jump you've got a lot more i/o throughput capability in the node. On one machine migration that I worked on (albeit with different node types involved) we saw comparitive speed-up of between 1 and 12-15 times, so it is very variable.
If you want to compare two machines, try using the portion of a query that only uses Teradata resources. An Insert/Select, Update, Delete etc or maybe use a normal Select statement but ignore the response phase. I wouldn't use any of the load/unload utilities by themselves as they can be heavily dependent on host resources.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|