We had some timeout issues with the first version of CFMX and its default jvm.(I believe the default jvm had a known issue with timing out https requests) After a few posts here and the macromedia forums, I came away with the understanding that the timeout does NOT apply to external processes, including cfquery and cfhttp.
If the long running-ness is caused by an external process, you will see things in the log like "template ran 900 seconds" even with a timeout of 60 in the admin.
Long running cf-centric processes will obey the timeout specified.
I am not absolutely certain on this, however, so hopefully anyone one here more knowledgeable then I can clear up anything I got wrong. Just figured I would put something out there, if anything to help guide you own research.
Cheers,
Matthew
-Original Message-
From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 12:39 PM
To: CF-Talk
Subject: RE: Request timed out - what does this mean?
Usually when I see this happen is when I've written a poor query and the
database server is taking longer to process said query than the CF Admin
allows. In this case, the CF request is ended, but the database is still
processing my request. The database server will churn and churn on the
problem until it's finished, but by that time, the result has no place to go
to.
-Original Message-
From: Earl, George [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 1:34 PM
To: CF-Talk
Subject: Request timed out - what does this mean?
When CF terminates a request based on the timeout parameter set in the CF
Admin, and when the request being terminated is an SQL query or a request to
a stored procedure (i.e., the error message in the log includes the SQL or
the name of the stored procedure), is it safe to assume that the request
ended with the answer set from the SQL or stored procedure still not
returned to the web server? Or could it be that the answer set came back to
the web server and the cfm page is still processing it? Thanks!
George
[EMAIL PROTECTED]
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
