Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2010 @ 13:59:00 GMT

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

Hi Paul,

Glad to hear it got solved.

Just out of interest, how quickly does it now run ?

Even with very skewed data I don't think any real TD system should have taken that long to process so few rows. Assume it took 3 hours to do the update and all rows were on the same AMP:

     - 3 hours = 10800 seconds
     - this is 0.06 rows per second.

There's something else going on here (which we may never get to the bottom of this).

Cheers,

Dave

Ward Analytics Ltd - Information in motion ( www.ward-analytics.com )

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