Query of Query Timeout

2006-12-05 Thread Dave Phillips
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

RE: Query of Query Timeout

2006-12-05 Thread Bobby Hartsfield
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

RE: Query of Query Timeout

2006-12-05 Thread Ian Skinner
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

RE: Query of Query Timeout

2006-12-05 Thread Snake
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

RE: Query of Query Timeout

2006-12-05 Thread Ian Skinner
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

RE: Query of Query Timeout

2006-12-05 Thread Brad Wood
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