Is there any way to time how long it takes for a r...
# cfml-generalp
Patrick
05/05/2022, 1:14 PMIs there any way to time how long it takes for a response to return to the CF box from say a DB server/request? Not the execution time of the query, literally just the request to the DB server?
t
thisOldDave
05/05/2022, 1:30 PMyou could probably get something from wireshark I know you can get packet timings https://www.wireshark.org/docs/wsug_html_chunked/ChWorkTimeFormatsSection.html
c
chris_hopkins
05/05/2022, 1:30 PMwas going to say fusion reactor but after checking it does not split out the roundtrip time
p
Patrick
05/05/2022, 1:31 PMyea we are trying to bypass the server admins and prove to them that their is a bottleneck in our requests hitting the db box via some cf or java method directly in our code so we have a proof of concept.
Patrick
05/05/2022, 1:32 PMSo basically zero access to boxes except in the CF code
c
chris_hopkins
05/05/2022, 1:32 PMcould you somehow get the run time from the query itself ? then compare that with the complete time
p
Patrick
05/05/2022, 1:34 PMbut that is the execution of the query included in that time
Patrick
05/05/2022, 1:35 PMbasically they are trying to blame our queries so trying to take that out of the equation
c
chris_hopkins
05/05/2022, 1:35 PMi would think if you had the execution time from the database itself that should be just that - then compare total time in CF
chris_hopkins
05/05/2022, 1:35 PMexectution - total = round trip
chris_hopkins
05/05/2022, 1:35 PMother way around though lol
chris_hopkins
05/05/2022, 1:38 PMwhat database are you working with?
j
John Varady
05/05/2022, 1:39 PMtry running a very simple query with 0 execution time? "SELECT 1 FROM DUAL" should do it in most dbs.
👍🏻 1
👍 1
r
rstewart
05/05/2022, 2:19 PMget a timestamp in the cf code right before and right after the cfquery?
Copy code
<cfset ts0 = gettickcount() />
<cfquery ... >
</cfquery>
<cfset ts1 = gettickcount() />rstewart
05/05/2022, 2:21 PMor
Copy code
ts0 = gettickcount();
queryExecute(...);
ts1 = qettickcount();rstewart
05/05/2022, 2:22 PMwe’ve used that approach in the past to identify places where there is other latency/lag.
rstewart
05/05/2022, 2:27 PMthat will get total time, but it doesn’t differentiate between time TO the database server and time for the results to come back FROM the database server but it can help show if the to+from is significantly larger than the actual execution time.
p
Patrick
05/05/2022, 4:21 PMYea all of those seem like a good approach; I am going to add them to my mock to see where latency is occurring and prove to the DBAs heh.
Patrick
05/05/2022, 4:21 PMThanks for all the feedback!
r
rstewart
05/05/2022, 4:23 PMGood luck. I’ve seen this movie a couple of times. Our version of it usually devolves into finger-pointing and name-calling between the various groups of app devs, sys admins, DBAs, and network admins.
rstewart
05/05/2022, 4:25 PM… and usually the cybersecurity group gets blamed for onerous requirements, primarily because they never participate in the conversations.
p
Patrick
05/05/2022, 7:42 PMOh yea, its already been a finger pointing game since the beginning haha.
2 Views