Connection pooling

[Guest]

Hi
we have Windows Applcation with sql server 2000.i want to enable connection
pooling in database for best perfomance.
i added connection string in app.config this

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="basicConnect"
value="server=10.150.142.178;database=OMTOOLSDB;Trusted_Connection=true;Pooling=true;Max Pool Size=100;Min Pool Size=0"/>
</appSettings>
</configuration>



after adding this also i was not finding any difference in performance

how can i check performance after enabiling pooling

 

[Patrice]

Pooling is already enabled by default.

A test could be to create/dispose a connection in a loop. If you then
*disable* pooling it should be much more slower to execute the same loop....

Patrice

--

Hi
we have Windows Applcation with sql server 2000.i want to enable connection
pooling in database for best perfomance.
i added connection string in app.config this

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="basicConnect"

value="server=10.150.142.178;database=OMTOOLSDB;Trusted_Connection=true;Pool
ing=true;Max Pool Size=100;Min Pool Size=0"/>

 

[Guest]

If it is oledb then it is a default what about sqlconnection is it default or
we need to specify in connection string??

 

[Miha Markic [MVP C#]]

Hi,

Are you opening connection right before operation and closing it immediately
after?
Also, on single threaded applications there will be no difference.

 

[Patrice]

This is always the default. You have to tell when you want to disable
pooling...

Doing the loop described previously should easily convince you...

Patrice

--