How to Increase ColdFusion Timeout

Question

I have a CFM Page where I call a Stored Procedure. The page seems to be timing out due to the query taking too long to execute. We have tried optimizing/tuning the SQL query, made Clustered and Non-Clustered Indices , but the query is still taking around 4 minutes to execute.

Now , the only way to solve this is to increase the Cold Fusion Timeout in the Front End. But ,I have tried increasing the timeout by using the below snippet on the CFM page.

<cfsetting requestTimeOut="600">

But this is not working. The page keeps timing out after 120 seconds and throws the timeOut Error. We have also tried to pass a URL parameter "requestTimeout=600" but still the page is getting timed out after 120 seconds.

Can you please suggest a solution to increase the TimeOut in ColdFusion other than the ways we have tried above.

I am using Cold Fusion MX 7 and i'm afraid its not picking up this timeout attribute. :( — user3114356, Jan 28 '15 at 13:28

score 1 · Answer 1 · edited Jan 28 '15 at 15:27

1

Cfstoredproc has a timeout attribute you can use. Documentation is here.

Edit Starts Here

For MX7, try a cfquery tag

<cfquery timeout = something>
exec yourProcedure
@param1 = <cfqueryparam etc>
etc
</cfquery>

edited Jan 28 '15 at 15:27

Leigh

28,765
10
55
103

answered Jan 28 '15 at 10:47

Dan Bracuk

20,699
4
26
43

I am using Cold Fusion MX 7 and i'm afraid its not picking up this timeout attribute. :( – user3114356 Jan 28 '15 at 13:28
1

This is not a 'link only' answer. He states there is an attribute and gives the correct name for it. If the OP cannot figure it out from there...he can use the link. – Scott Stroz Jan 28 '15 at 14:34
For my own curiousity, was the downvote based on the the part above or below the Edit Starts Here line? – Dan Bracuk Jan 28 '15 at 16:48
We are using BlueDragon Cold Fusion combination. And I read somewhere that passing the timeOut parameter through and tags is not supported. – user3114356 Jan 30 '15 at 10:47
Is there any other way to go around this? – user3114356 Jan 30 '15 at 10:49

score 0 · Answer 2 · answered Jan 28 '15 at 14:52

You can call a stored procedure using the cfquery tag instead of the Cfstoredproc tag. Below a simple example:

<cfquery name="qryName" datasource="#yourdatabase#">
call nameOfStoredProcedure( #yourvariables#);
</cfquery>

I use mysql as the back end database engine, i do not know if this also works with other database engines.

How to Increase ColdFusion Timeout

2 Answers2