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 |
How would you deploy your old applications with .net framework 4.0? Are the old applications compatible?
Can we create the web service in windows application?
How is method overriding different from method overloading
What is difference between razor and web form engine?
What is storage model? : Entity framework
what is scalar property?
How does servicing work for the .net framework 3.0? If I install the .net framework 3.0, can I get service updates for the .net framework 2.0?
Why should we go for entity framework?
How to free the memory that is not used by an object in garbage collection?
Explain Keep method in Tempdata in ASP.Net MVC?
What is stateless model?
Describe the roles of clr in .net framework.?