RE: Request running time

[Hrncir, Garrett (DAL)]

You should be able to get the processing time of a database insert with cfquery.ExecutionTime   As far as getting the processing time before the query starts, have you tried cftrace? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-c14.htm#wp2698629   -------------------------- Garrett Hrncir Web Technology Jackson Lewis LLP   From: Tom Woestman [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 31, 2005 11:38 AM To: list@dfwcfug.org Subject: Request running time Is anyone aware of a built in CF variable that returns the amount of time the current request has been processing?  I am working to track an intermittent timeout problem (30 seconds) that sometimes happens on a database insert.  The database insert usually requires 20 ms or so.    I am adding code to track how long it takes to process the insert and if it is overly long do some notification.  I would like to know how long the request has been processing before the query starts so I can get an idea if some other part of the code is taking almost all the 30 seconds available to the request with this final insert being the 'last straw' pushing the request over the time limit.   I am aware I could set a request variable with the getTickCount() value at the start of the request but would like to avoid this if a built in variable is available.   Thanks in advance for your help, Tom Woestman