Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 25 Oct 2002 @ 16:43:17 GMT


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


Subj:   Re: Execution times for queries
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, October 25, 2002 11:43 -->

Execution time of a query = Total time - (logon and logoff time).

So to measure logon/logoff time, build a process that does logon/logoff numerous times. Measure elapsed time. Add the query and repeat. Of course again, measure the elapsed time. Subtract the two times. This result gives the query time. (Simple arithmetic steps left out for brevity).

This is the most accurate method I have been able to use. It also yields network traffic time and interference from infrastructure - routers, hubs, etc.



     
  <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