Has anyone ever experienced a query of query timeout? I have a Query of Query
that I am running against a result set that has several thousand records in it
(no more than 8,192). From time to time (more often than not) the page fails
on a 'The request has exceeded the allowable time limit Tag
back to
normal before I can catch it.
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 05, 2006 10:57 AM
To: CF-Talk
Subject: Query of Query Timeout
Has anyone ever experienced
The amount of time that ColdFusion will allow for a tag to complete is a
setting in the administrator that defaults to 60 seconds. You can bump this up
if required.
Alternately you can replace your QofQ with potentially better performing logic.
At a conference a couple of months ago, a CF
It would be an array of strutures.
Each array being one row, and containing a struture key for each column
Russ
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: 05 December 2006 17:30
To: CF-Talk
Subject: RE: Query of Query Timeout
Interesting. In this case
Is that basically an array of structures or a structure of arrays? Or a
structure of structures?
Any of the above, you would just output the query into a structure of your
design and then use that structure for future filtering and processing. This
is apparently one of those 9 out of 10 kind
PROTECTED]
Sent: Tuesday, December 05, 2006 11:05 AM
To: CF-Talk
Subject: Re: Query of Query Timeout
Here's another question. I added a
cfoutput#getTickCount()#/cfoutputbr line directly after my
CFSEARCH tag (and before my QofQ) and now the timeout is happening on
that CFOUTPUT tag. Taht seems
Hello,
I have a unique situation that I only have limited control over. I was
hoping someone on the list could provide some assistance.
Here is my issue. A have a CF Site on a shared hosting account at
Crystaltech. The database is Access. This was fine for a certain
amount of time but now
service and for CF itself as it
queues up all those connections.
Best, don't use Access. Get your client to export the data to a CSV and
import that.
Russ
-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: 09 October 2005 14:32
To: CF-Talk
Subject: CF Query Timeout
Hello
Why does this never actually work. I am running a query on an ODBC datasource. The
ODBC is connecting to an informix database. I don't want the query to take longer
then 30 seconds. Not that coldfusion cares what I tell it the timeout value is.
The main question is: Why does the timeout not
Why does this never actually work. I am running a query on
an ODBC datasource. The ODBC is connecting to an informix
database. I don't want the query to take longer then 30
seconds. Not that coldfusion cares what I tell it the
timeout value is.
The main question is: Why does the timeout
10 matches
Mail list logo
