Connection pooling

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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

--

TreeView Custom said:
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"
Click to expand...
value="server=10.150.142.178;database=OMTOOLSDB;Trusted_Connection=true;Pool
ing=true;Max Pool Size=100;Min Pool Size=0"/>
 
If it is oledb then it is a default what about sqlconnection is it default or
we need to specify in connection string??
 
Hi,

Are you opening connection right before operation and closing it immediately
after?
Also, on single threaded applications there will be no difference.
 
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

--
 
Back
Top