You should be able to output #cfquery.executionTime# to receive the execution time results for all queries.
You can also set the debug attribute on each query. HTH Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Ferguson Sent: Thursday, December 02, 2004 6:05 AM To: [EMAIL PROTECTED] Subject: RE: SQL Query Aggregate Sorry I don't have more time to help today, but here's a starting point and I'll try to add more information later (more likely, next week). Save the following code to a template and run it on a page where some queries are running and you will see the queries' text. If you back up and take the WHERE clause out of the query, you'll see the body with all types... <CFIF IsDebugMode()> <CFOBJECT ACTION="CREATE" TYPE="JAVA" CLASS="coldfusion.server.ServiceFactory" NAME="factory"> <CFSET cfdebugger=factory.getDebuggingService()> <!--- Load the debugging service's event table ---> <CFSET events = cfdebugger.getDebugger().getData()> <!--- Get SQL statement (body) for specified query ---> <CFQUERY DBTYPE="query" NAME="getqueries" DEBUG="false"> SELECT body FROM events WHERE type='SqlQuery' </CFQUERY> <cfdump var="#getqueries#"> </cfif> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Meilinger Sent: Wednesday, December 01, 2004 2:59 PM To: [EMAIL PROTECTED] Subject: SQL Query Aggregate Hey all, I'm trying to do some SQL query tuning for a large application I support. Anyone know of a way to futz with the CF ServerFactory to get a aggregate of all the queries run for a particular page? Basically, I am trying to get a total of all the query times presented in the typical CF debug output and it would be nice to be able to do that without manually calculating it for each different page of an application. Any advice would be appreciated! ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
