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: CFQUERY' error. This is a Q of Q that is basically filtering out some records in the original result set. It uses a LIKE search (which I know is a no-no on databases, but haven't had trouble before on QofQ's).
Any thoughts? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4