I've got an app running on CFMX6.1 Updater 1 with SQLServer 2000. I
have a problem with queries timing out sporadically. They're using
cfqueryparam so I've run the profiler and grabbed what CF is sending:
declare @P1 int
set @P1=NULL
exec sp_prepexec @P1 output, N'@P1 varchar(8000)', N'SELECT
[RExpense],
[RIndemnity],
[RMedical],
[RTotal]
FROM vwClaims_filtered
WHERE (
(Claim_Status = @P1 )
AND
(1=1) )
ORDER BY
ACIG_CLAIM_NUMBER DESC,
null', 'open'
select @P1
AND I've run it through query analyzer and it runs in 10 seconds, but
will time out in CF. Any ideas as to why this is?
Thanks
--
All Hail King George VII
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227944
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
