Interested to Buy Any Domain ? << Click Here >> for more details...
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
Is bulk insert faster than insert?
How to identify the updated rows in a dataset?
Where is adodb dll located?
How to pass multiple tables in datasets simultaneously?
Which database is the ado.net sql connection object designed for?
Define different execute methods of ADO.NET command object ?
Why edit is not possible in repeater?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is the difference between ado.net and entity framework?
How is it possible to get 2 tables of data at a time by using data reader?
How to enable and disable connection pooling?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What are good ado.net object to replace to ado recordset object.
What do you know about ADO.NET's objects and methods?
What are the classes in System.Data.Common Namespace?
