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]
