Re: changing a Clinet/Server application to use connection pooling

Thanks Brian, that's what I thought.

Is there anything documented anywhere detailing the benefits of having an
application use connection pooling or keeping 1 dedicated connection?

Thanks

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:6vmll1leg1de0cppq11qg23no6hmcdj8dr@xxxxxxxxxx
>
>>Ok, I see that, but is there not another way of doing connection pooling?
>>Like I said, I have one ADO connection in my app that is always open from
>>the start to shutdown of the app.
>>Does this still mean that connection pooling is happening.
>
> Connection pooling is happening but if your app is holding on to a
> connection it
> doesn't need the benefit of connection pooling.
> Connection pooling holds connections that are released by an application
> open
> for a while so that the next application that needs a connection can use
> one of
> the open connections.
>
>
> --
> Brian Bushay (TeamB)
> Bbushay@xxxxxxxxx


.

Relevant Pages

  • MTA with thread pool API
    ... The app uses a completion port for socket I/O, ... properly implement connection pooling with OLE DB. ... So I'm rewriting this app to maintain one IDataInitialize object, ... do for proper connection pooling. ...
    (microsoft.public.data.oledb)
  • Re: [JDBC] Connection pooling
    ... of course you should only use a tomcat when your app is a webapp. ... > Here are a few things I don't understand about connection pooling. ...
    (comp.lang.java.databases)
  • Re: Primary Key with a datetime datatype
    ... Perhaps the app passes appropriate SET DATEFORMAT command, ... thinking things like connection pooling etc. ... I'd strongly suggest to the app vendor to use a "safe" format. ...
    (microsoft.public.sqlserver.server)
  • Re: changing a Clinet/Server application to use connection pooling
    ... >Thanks Brian, that's what I thought. ... >Is there anything documented anywhere detailing the benefits of having an ... >application use connection pooling or keeping 1 dedicated connection? ...
    (borland.public.delphi.database.ado)
  • Re: Connection Pooling
    ... the app. ... Since all connections have to be killed anyway, ... > Part of the app is a 'Restore from Backup' form which uses SQLDMO code. ... > I'm starting to think it's to do with connection pooling because the open ...
    (microsoft.public.dotnet.framework.adonet)