> -----Original Message----- > From: Tom Chiverton [mailto:[EMAIL PROTECTED] > Sent: Monday, February 11, 2008 1:49 PM > To: CF-Talk > Subject: Re: Maintain client connections - not working in CF8 / SQL > 2000 > > On Monday 11 Feb 2008, Paul Vernon wrote: > > notifications for the CF db user accounts. The rate is at least 1 > > successful DB connection every second... > > Nice busy site :-) > Connection pooling will obviously slow things down, but I wouldn't > expect it to kill the database, unless lots of your queries are long > running...
Quite a few busy sites in fact :-) This particular server hosts careers sites for a couple of major high street names in the UK :-). None of the queries are long running, I run SQL profiler on a regular basis to help with that and the majority of queries run in under 20ms. > > Also, the server is a production server that had an in situ upgrade > from > > CF6 for CF8. It didn't do this until CF6 was installed... > > I assume you mean 8, in which case a lot 'under the hood' changed. > Have you tried deleting and readding the DSN ? I did mean 8 and no, that didn't occur to me. I guess that would be a DOH! on my part. I'll give it a go with one of the busier sites and see what happens... Cheers Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
