Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 17 May 2012 @ 15:05:04 GMT

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

Subj:   Re: Performance between development and production systems
From:   Dave Wellman

Hi Christer,

When looking at the two explain plans (2 seconds in development and 83 seconds in production_, what are the row counts like ? Are they in the right order of magnitude? What are the comparitive data volumes in production and development?

You also say that there seems to be a delay in production of 30-60 seconds before the query 'starts'. What exactly are you measuring here ? In production have you got TASM throttles in place and that time is how long it takes for your queries to reach the front of the queue ?



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: 28 Jun 2020