[cfaussie] Re: Connection Pooling

2007-09-25 Thread silverbeetle
the website is www.billyhydemusic.com.au the host is web central On Sep 25, 5:20 pm, "Brett Payne-Rhodes" <[EMAIL PROTECTED]> wrote: > And, out of curiosity, the URL of the site perhaps? > > B) > > Darren Tracey wrote: > > On Sep 25, 2:49 pm, silverbeetle <[EMAIL PROTECTED]> wrote: > >> huge tha

[cfaussie] Re: Connection Pooling

2007-09-25 Thread Brett Payne-Rhodes
And, out of curiosity, the URL of the site perhaps? B) Darren Tracey wrote: > On Sep 25, 2:49 pm, silverbeetle <[EMAIL PROTECTED]> wrote: >> huge thanks to sean for really giving my problem some attention. best >> service i've had from an isp to date! Looking forward to seeing what >> improveme

[cfaussie] Re: Connection Pooling

2007-09-25 Thread Darren Tracey
On Sep 25, 2:49 pm, silverbeetle <[EMAIL PROTECTED]> wrote: > > huge thanks to sean for really giving my problem some attention. best > service i've had from an isp to date! Looking forward to seeing what > improvements i can make at my end (stored procedures) and see how the > changes you've made

[cfaussie] Re: Connection Pooling

2007-09-24 Thread silverbeetle
Message- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > > Of silverbeetle > Sent: Tuesday, 25 September 2007 2:49 PM > To: cfaussie > Subject: [cfaussie] Re: Connection Pooling > > big thanks to charlie for that info. i didnt have much l

[cfaussie] Re: Connection Pooling

2007-09-24 Thread Steve Onnis
Out of curiosity chris , how many hits do you get a day? -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of silverbeetle Sent: Tuesday, 25 September 2007 2:49 PM To: cfaussie Subject: [cfaussie] Re: Connection Pooling big thanks to charlie for

[cfaussie] Re: Connection Pooling

2007-09-24 Thread silverbeetle
big thanks to charlie for that info. i didnt have much luck on google when searching for info on this either. huge thanks to sean for really giving my problem some attention. best service i've had from an isp to date! Looking forward to seeing what improvements i can make at my end (stored proced

[cfaussie] Re: Connection Pooling

2007-09-24 Thread Sean Bucklar
Charlie Arehart (lists account) wrote: > OK, here's the longer note with some thoughts. > First, as for their recommendation to "revise your code and ensure that you > are utilising connection pooling", it could be that your host is more > familiar with .NET, Java, or other languages where one do

[cfaussie] Re: Connection Pooling

2007-09-24 Thread Charlie Arehart \(lists account\)
o let you use more connections, or change plans, or change hosts. Hope that's helpful to you and others. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of silverbeetle Sent: Sunday, September 23, 2007 7:46 PM To: cfaussie Subject: [cfaussie

[cfaussie] Re: Connection Pooling

2007-09-24 Thread Charlie Arehart \(lists account\)
m [mailto:[EMAIL PROTECTED] On Behalf Of silverbeetle Sent: Sunday, September 23, 2007 7:46 PM To: cfaussie Subject: [cfaussie] Re: Connection Pooling Hey Barry Well - could well be a scapegoat. i think my code is pretty clean and efficient. I dont have any long running queries apart from a few

[cfaussie] Re: Connection Pooling

2007-09-23 Thread silverbeetle
Hey Barry Well - could well be a scapegoat. i think my code is pretty clean and efficient. I dont have any long running queries apart from a few admin related ones. Some of the nav is generated from queries but this is all cached to avoid database getting hammered with each users request. So i

[cfaussie] Re: Connection Pooling

2007-09-22 Thread Charlie Arehart \(lists account\)
] On Behalf Of Barry Beattie Sent: Saturday, September 22, 2007 12:26 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Connection Pooling > I'm always surprised to see someone mention only SeeFusion. It's a > great product, but there is also FusionReactor. I'd be surp

[cfaussie] Re: Connection Pooling

2007-09-21 Thread Barry Beattie
> I'm always surprised to see someone mention only SeeFusion. It's a great > product, but there is also FusionReactor. I'd be surprised one could hear of > one but not the other. :-) Anything more to just mentioning the one, Barry? mea maximus culpa, Charlie. FusionReactor is indeed worth mention

[cfaussie] Re: Connection Pooling

2007-09-21 Thread Charlie Arehart \(lists account\)
e info on connection pooling. CF8's monitor does, however, though only on Enterprise/Developer. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Friday, September 21, 2007 8:36 AM To: cfaussie@googlegroups.c

[cfaussie] Re: Connection Pooling

2007-09-21 Thread Barry Beattie
in that case my curiosity has been piqued... only closed connections can be returned to the pool, yes? what would be keeping a bunch of connections open? excessively long queries? a cftransaction gone silly? a trapped error running a query, taking too long to get resolved? pity it's not cf8 wi

[cfaussie] Re: Connection Pooling

2007-09-21 Thread Sean Bucklar
Barry, I'd guess not. Assuming Chris hosts with who I think he does, it's an auto generated notice from a threshold exceed alert on db monitoring. It's not a reactive 'oh no, there's a problem, scapegoat someone!' notice - it's proactive monitoring of a threshold determined by the product level.

[cfaussie] Re: Connection Pooling

2007-09-20 Thread Barry Beattie
Chris, are you sure they're not just picking on you and treating you as a scapegoat for some other problem? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfau

[cfaussie] Re: Connection Pooling

2007-09-20 Thread silverbeetle
Hey MrBuzzy - they allow a maximum of 35 simultaneous connections. And i'd like to think i don't have any dodgy coding but if you could think of any examples where things could be going wrong i'm all ears :) Mark - no, i'm not using any manual connections or anything out of the ordinary. Might hi

[cfaussie] Re: Connection Pooling

2007-09-20 Thread MrBuzzy
Maybe you just need to reduce the number of connections in the pool. Did your web host say how many connections they'd like you to have??? Also, it is possible to use up all those connections with some dodgey CF coding, sorry I can't think of a concrete example right now :) On 9/20/07, Mark Mande

[cfaussie] Re: Connection Pooling

2007-09-19 Thread Mark Mandel
It should be something that is handled inside ColdFusion administrator. Are you using any code that manually creates a connection to the DB using Java? Any sort of ORM Framework maybe? Transfer, Hibernate? Something else? Mark On 9/20/07, silverbeetle <[EMAIL PROTECTED]> wrote: > > Hello all!