 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Jan 2001 @ 10:23:37 GMT
| Subj: | | Re: Performance/Power |
| |
| From: | | David Wellman |
Warren,
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.
Regards,
Dave
| |
