Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Time Stamp

Status
Not open for further replies.

craig322

MIS
Apr 19, 2001
108
US
Is there a way to get the actual query response time? I currently have scripts that get a timestamp, run the query,
then get an end time stamp. I want to know the actual query run time so I can insert it into a table, not manually collect times and calculate a run time.

TIA

Craig
 
Every Terdata query ends with a "Total Elapsed time" . You should be able to redirect the output of the SQL to a file and get the elapsed time from the file ...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top