what is connection pooling
Answers were Sorted based on User's Feedback
Answer / akash verma
connection pooling is a pool which contains connections which are not in working but when they are required they are fetched from the connection pool and when the work is finished they again go back in the connection pool for next call.Thus there is no need to create new connection again and again, the same connection can be used only by calling it every time.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shipra agarwal
Coonection pooling Where several of threads reagrding
connection are stored.Whenver they required just fetched
from the pool.After when their work finished again they go
back to the pool for next calling.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / narayanaprasad
Connection Pooling can increase the database performance to
a huge extent. This article discusses what Connection
Pooling actually is, how it can boost the performance of
database access and how we can create a Connection Pool in
.NET and add and remove connections to it.
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / krishana bihari singh
Pooling connections can significantly enhance the
performance and scalability of your application. The .NET
Framework Data Provider for SQL Server provides connection
pooling automatically for your ADO.NET client application.
You can also supply several connection string modifiers to
control connection pooling behavior (see the
section "Controlling Connection Pooling with Connection
String Keywords" later in this topic).
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / padmaja
suppose we can create one connection and place that
connection in a pool.then,no need to create new connection
when we required.we can reuse from that connection pooling.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between .net core and .net framework?
what is linq to entities?
What are the advantages of mvc over asp.net?
What are the sub types of ActionResult?
Is there built-in support for tracing/logging
How to bind table colum with gridview column?
mention what are the various methods provided by the dataset object to generate xml?
What is the meaning of unobtrusive javascript?
If we write any code for DataGrid methods, what is the access specifier used for that methods in the code behind file and why?
What operating systems will the .net framework 3.0 be available for?
What does CLR do as soon as an assembly is created ?
What is connected scenario? : Entity framework