Archives of the TeradataForum

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

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

<-- 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>>