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
can we create synonymn in ms access,sql server,my sql if so explain me with example
What we do with the object of ado.net dataset after using it?
How do you update a dataset in ado.net and how do you update database through dataset?
What is aggregating data ?
What are the several execute methods of ado.net?
What is aggregate root?
What are the key features of ado.net?
What are different layers of ADO.Net?
Which is better ole db or odbc?
What are the rules to implement connection pooling?
How would you connect to a database by using .NET?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
How can you add or remove rows from the datatable object of dataset?
What are the different methods available under the sqlcommand class to access the data?
What is ole db and odbc?
