is sure to be a false positive.
<cfstoredproc procedure="upu_Instance_GetChildren "
datasource=""#Request.Application.DSN#">
<cfprocparam dbvarname="@ParentID "
value="#request.application.domainid#"
type="In"
cfsqltype="CF_SQL_INTEGER"
null="No">
<cfprocparam dbvarname="@ObjectType "
value="#request.object.object_page.type#"
type="In"
cfsqltype="CF_SQL_INTEGER"
null="No">
<cfprocresult name="rsYourResultsSet" resultset="1">
</cfstoredproc>
________________________________________
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 12:51
To: CF-Talk
Subject: RE: Tuning DB connections?
I am aware it cannot be used as a performance benchmark against
ColdFusion, but it is a performance benchmark of the query and the way
it is executed within SQL Server. The stored procedure call is :
<cfquery name="qrySubSubPages" datasource="#Request.Application.DSN#">
EXEC dbo.upu_Instance_GetChildren
@ParentID = #request.application.domainid#,
@ObjectType = #request.object.object_page.type#,
</cfquery>
This stored procedure is taking 0ms in QA (Also profiler states it has a
low cpu hit). It is also taking 0ms in #cfquery.executiontime# .......
when it likes to. So I am wondering, what is in the way which could
cause such big big performance decrease on some occasions. If it was 0-5
ms, I would say.. well okay could be latency. But in 50% of the cases
cfquery.executiontime returns 16ms, and I am wondering why. :-)
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL��Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
________________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
