Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is connection pooling ?

Answer Posted / madhunathanv

Apart From def of Connection Pooling
Connection pooling has 4 parameters:

1.)Connect Timeout - controls the wait period in seconds
when a new connection is requested, if this timeout
expires, an exception will be thrown. Default is 15
seconds.
2.)Max Pool Size - specifies the maximum size of your
connection pool. Default is 100. Most Web sites do not use
more than 40 connections under the heaviest load but it
depends on how long your database operations take to
complete.
3.)Min Pool Size - initial number of connections that will
be added to the pool upon its creation. Default is zero;
however, you may chose to set this to a small number such
as 5 if your application needs consistent response times
even after it was idle for hours. In this case the first
user requests won't have to wait for those database
connections to establish.
4.)Pooling - controls if your connection pooling on or off.
Default as you may've guessed is true. Read on to see when
you may use Pooling=false setting.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name which operations can you not perform on an ado.net dataset?

985


How to Read, Add, Update and Delete record in Entity Framework ?

1040


What are all components of ADO.Net data provider?

1060


What is the difference between data grid and data repeater?

1079


What is fill method in ado.net?

981


can we create synonymn in ms access,sql server,my sql if so explain me with example

2087


What is ado and dao?

960


Why do we need ado.net?

967


Which object of ado contains datarow datacolumn collection?

966


Explain executenonquery?

1135


What is datatable in ado.net?

969


Explain what are acid properties?

991


What is a string variable?

917


Describe connection object in ado.net

1045


What is the difference between Datareader and Dataset?

1083