if you have two concurrent requests, CF will open two connections to the DB.
It's slightly more overhead that is strictly needed (you could release
connections after each transaction, and regain them for the next). However,
talking to the connection pool might actually be more overhead that opening
a couple extra connections to the DB, since RDBMSs are specifically designed
to service multiple clients.
I seem to recall that CF will close out connections from it's pool and
reopen new ones after a certain amount of <something>. Don't know if it was
time, number of queries, or even whether it's still around. Might have just
been back in the 4.5 days.
Cheers,
barneyb
> -----Original Message-----
> From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 23, 2004 9:58 AM
> To: CF-Talk
> Subject: Re: Understanding/Defending Coldfusion connections
>
> Actually, the option to maintain database connections doesnt seem to
> really work (for J2EE ---> Oracle). Even with maintain connection
> checked we notice that Oracle still creates multiple sessions.
>
> The workaround we put in place was to make our DB calls through a java
> api that could do a much better job of maintaining the connection.
>
> So CF acts contrary to what this voice of authority claims.
>
> -Adam
>
>
> ----- Original Message -----
> From: G <[EMAIL PROTECTED]>
> Date: Wed, 23 Jun 2004 11:42:21 -0500
> Subject: Re: Understanding/Defending Coldfusion connections
> To: CF-Talk <[EMAIL PROTECTED]>
>
>
> You're right, MS has done a good job of getting the word about .NET
> out. As such, we developers are almost obligated to familiarize
> ourselves with its capabilities (and shortcomings) so that we can make
> the correct tech decisions for ourselves, our companies, our clients,
> etc.
>
> "Microsoft" carries such weight that if you're going to recommend a
> different solution to a customer, you'd better have solid reasons to
> back them up. The fact that .NET is not preceded by "CF" is probably
> not going to get it done :)
>
> Brian
>
> ----- Original Message -----
> From: Ray Champagne
> To: CF-Talk
> Sent: Wednesday, June 23, 2004 10:52 AM
> Subject: Re: Understanding/Defending Coldfusion connections
>
> I'd be very interested in that too. MS certainly has been
> good at getting
> the word out about .NET, and therefore all of our clients
> are convinced
> that they 'need' it. I'd love to have more ways to
> convince them otherwise.
>
> Ray
> http://www.crystalvision.org
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
