Browser timeout during SQL execution
Posted on 2004-09-20
Coldfusion MX 6.1
SQL server 2000 sp3
I am having problems with browser timeouts during long-running SQL tasks executed through <CFQUERY>
The process runs for about 30 seconds then I get this in the browser window
The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.
I have already added this <cfsetting requesttimeout="10000">
and I have changed the timeout settnig to 600 in the CFIDE admin tool.
I also added <cfflush> throughout.
One last thing... I have verified both through QA testing the tables and through SQL server traces that the code continues to execute AFTER the server sends the "The page cannot be diplayed to browser"...so i know that the SQL is valid...100% sure. Are there settings on the client that cause the browser to timeout? What am I missing?
One last thing... SQL 2 and 3 (see below) take about 3 minutes to execute on average according to the trace.
<!--- this procedure loads the table
<title>Process permit fact table</title>
<h3> Processinig fact table updates...this may take a couple minutes</h3>
<cfloop from="1" to="4" index="i">
<cfquery name ="elt_fact#i#" datasource="reports">
[ First SQL here...]
<h3>rows inserted...updates started</h3>
<cfquery name="etl_fact_metrics" datasource="reports">
[Second SQL here]
<h3>Almost there...one more update!</h3>
<cfquery name="etl_perm" datasource="reports">
[Third SQL here]
fact table processed successfully