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


>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: 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)
  • Re: changing a Clinet/Server application to use connection pooling
    ... Ok, I see that, but is there not another way of doing connection pooling? ... I have one ADO connection in my app that is always open from ... >>connection to connect to SQL server work in connection pooling and what ...
    (borland.public.delphi.database.ado)