Conection Pooling with multiple applications

[ind_123]

Can connection pooling be implemented for multiple applications? How
is it done?

[Alvin Bruney [ASP.NET MVP]]

Re: Conection Pooling with multiple applications

what environment are we talking? windows? web? web connection pooling is on
by default. windows, you need to turn it on through the connection string
property.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------




"ind_123" <dhulapati@gmai l.comwrote in message
news:92dd9be3-6728-4f54-a394-1adcc23b9f22@f6 3g2000hsf.googl egroups.com...

Can connection pooling be implemented for multiple applications? How
is it done?
>

[Marc Gravell]

Re: Conection Pooling with multiple applications

Are you sure about that? I haven't tested it, but most references I've
seen simply state "enabled by default on SQL Server" (or some-such),
without qualifying web vs windows - for example:

http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx

Marc

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Re: Conection Pooling with multiple applications

ind_123 wrote:

Can connection pooling be implemented for multiple applications? How
is it done?

[I will assume database connections]

Each application has its own pool.

Note that the database will get the sum of all the apps
connections, so consider number of apps when deciding
on pool size.

Arne

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Re: Conection Pooling with multiple applications

Marc Gravell wrote:

Are you sure about that? I haven't tested it, but most references I've
seen simply state "enabled by default on SQL Server" (or some-such),
without qualifying web vs windows - for example:
>
http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx

It is easy to verify that pooling works for a simple
console app by specifying Min Pool Size and call
sp_who.

Arne

[parez]

Re: Conection Pooling with multiple applications

On Apr 21, 5:42 pm, ind_123 <dhulap...@gmai l.comwrote:

Can connection pooling be implemented for multiple applications? How
is it done?

I think connection pools are connection string specific.. you will end
up having connection pool for each application(Con nString)