On the issue of query time outs, some of the queries which have time out are really simple (e.g., select the top 2 rows, 10 fields from one table), so it's not related to the query.
This started after our ISP moved the server to a new data center. All that has changed are the IPs of the servers. Is there anything specific we should be looking at? Thanks Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. -----Original Message----- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Thursday, February 19, 2009 9:15 AM To: 'cf-talk@houseoffusion.com' Subject: Query Caching Limit? The default limit in CF Admin for cached queries is 100. We do cache queries, but have had some issues with query timeout. Is there a larger limit I can set that would be reasonable? Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
