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
