Skip to main content

connection pooling


Explain about Connection Pooling?

  • Connection pooling is a concept which deals with database connection. A Connection Pool maintain last database connection active state when connection is ideal. Whenever you want to make a transaction with database once again you have to open connection when it is ideal, instead of that connection pooling will maintain open and reusable connections. A Connection Pool is released from the buffer or memory when the last connection to the database is closed.
  • By default Connection Pooling turned on in ado.net; whenever you want to change it off, you have to specify Pooling = false in the connection string .
  • We can specify limit to connection pooling by default the maximum limit is 100.
  • You will specify in connection string.
  • It will improves the performance and scalability of the application
It is managed by a program in ado.net that we called as Pool Manager. This program will maintain different connection request by comparing with maximum limit connection pool ,if number of connection are equal to max limit It will wait for new connection till another connection ideal or time out. If  connection is not in use then manager returns one, else it will create new connection and add to the pool.
Connection pool is managed with different parameters which are specified in connection string those are

   Connect Timeout
Min Pool Size
Max Pool Size
Pooling

Tomorrow will be with  Object Pooling?

Comments

Post a Comment

Popular posts from this blog

FAQS on DOTNET

Hello to every one who are fallowing my blog, today i attend one call from one Technical Recruiter (name is not required i think ) he asked some couple of question...ok i answered ....mean while  he asked one question (in my life never i feel it is relevant  for developer) who will use oops development environment? ha.. ha.. expect answer and update  to me   So far we received many request for FAQs on CSHARP, ASP.NET AND SQLSERVER for fresher who are in finishing schools. We are actively working with these Technologies  to bring   KEY   Resources for   TECHIES.                                   you are interested in helping others  bring  TECHKEYS   to your Friends through Social Media, please Leave the Comment to us to improve our work and subscribe  for more information .   Q 1) levels of nesting in a subq...
Post a Comment
read more »

SQLSERVER Functions- Coalesce()

SQL  Server  built-in functions Coalesce() It is A function Is Very Much Useful at Run time When We Have Multi Value Attribute in a Table. If U Consider below facts placed in a employee table With Id, Name, ph_no, Alt_no, Office no. id Name Ph_ no Alt_ no Office no 101 Albert 999999 456453 321333 102 khan null null 123455 103 victor 112121 null null 104 lovely null null 1897321 Above Employee table may have single value are three values if it have single value then it fill null  values with remaining attributes When We Retrieve The Number from employee table That Number Should Not be Null value To get not null value from employee table We Use Coalesce() Function It Returns First Encountered Not Null Value  from employee table select id , name , coalesce ( Ph_no , Alt_no , Office_no ) as contact...
Post a Comment
read more »

OOPS-Constructors and distractor

Hi friends today we will discussed about constructors and distractor in csharp Constructors are used to memory allocation for real world entities which are created with the help of objects. When program or application is running, application required memory to save and manipulate data of that real world object/entities. Now the question is how much memory is required for that object? Frankly no one can decide how much memory is required for that application because of that all object oriented programming languages depends on heap memory. Heap memory is a logical memory in RAM (temporary memory) and size is logically infinity (physically it is limited).This memory has to be creating at run time when we are using object in our program/application. Now we have to know that what type of data members we have in object. In object we have two types of data members’ object instance  shared instance Object instance are allocated occupies object memory and...
Post a Comment
read more »