Morning Adrian, thanks for getting back to me.
This is definitely not caused by the output/dump of the queries, even when all
those are removed it takes the same amount of time to return the page. This is
not a large query to return, simply a single row containing 2 columns. The
query looks as follows:
Select Sum(Case When d.LogClassName = 'org.thinkblue.TransferComplete' Then 1
Else 0 End) As SuccessSentCount,
Count(Distinct d.Device_ID) As UniqueDevicesCount,
Sum(Case When d.MinDate Is NULL Then 0 Else 1 End) As
FirstAppearanceCount
>From (
Select MessageLog.Device_ID,
FirstAppearance.MinDate,
LogClass.Name As LogClassName
From MessageLog
Inner Join LogClass
On LogClass.LogClass_ID = MessageLog.LogClass_ID
Left Outer Join (
Select Device_ID,
Min(LogDateTime) As
MinDate
From MessageLog
Inner Join LogClass
On LogClass.LogClass_ID =
MessageLog.LogClass_ID
Where LogClass.Name In (
'org.thinkblue.TransferComplete',
'org.openobex.Error.ConnectionRefused',
'org.openobex.Error.Forbidden',
'org.openobex.Error.NotAuthorized',
'org.openobex.Error.ConnectionTimeout'
)
And MessageLog.ThinkTank_ID =
<cfqueryparam value="#ARGUMENTS.ThinkTank_ID#" cfsqltype="cf_sql_integer" />
Group By Device_ID
) As FirstAppearance
On MessageLog.Device_ID = FirstAppearance.Device_ID
And MessageLog.LogDateTime = FirstAppearance.MinDate
Where LogClass.Name In (
'org.thinkblue.TransferComplete',
'org.openobex.Error.ConnectionRefused',
'org.openobex.Error.Forbidden',
'org.openobex.Error.NotAuthorized',
'org.openobex.Error.ConnectionTimeout'
)
And MessageLog.LogDateTime >= <cfqueryparam
value="#ARGUMENTS.StartDate#" cfsqltype="cf_sql_date" />
And MessageLog.LogDateTime < <cfqueryparam
value="#ARGUMENTS.EndDate#" cfsqltype="cf_sql_date" />
And ThinkTank_ID = <cfqueryparam
value="#ARGUMENTS.ThinkTank_ID#" cfsqltype="cf_sql_integer" />
) As d
Like I say, the query actually runs fine from SSMS but just not when run from
CF.
Cheers,
Rob
>To make sure it's not the display/debugging causing the issue, remove it
>all. A dump of a large query in Firefox with Firebug will take a while (I'm
>not saying 8 minutes, but a while!).
>
>Post the query too.
>
>Adrian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318154
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
