Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Field update running slowly
 
From:   DWellman

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023