Qus:    What are the basic requirements for connection pooling?
Oct 16, 2020 09:18 2 Answers Views: 601 ANANYA
Prev Next
Answers (2)
NAIDU Oct 19, 2020 02:33
Answer:   The following two requirements must be fulfilled for connection pooling:
o There must be multiple processes to share the same connection describing the same parameters and security settings.
o The connection string must be identical.

PARTH Oct 20, 2020 08:10
Answer:   Creating a database connection is somewhat time-consuming because it involves the overhead of network-level handshaking and security credentialing for each new connection request.

ADO.NET uses a technique called connection pooling, which minimizes the cost of repeatedly opening and closing connections. Connection pooling reuses existing active connections with the same connection string instead of creating new connections when a request is made to the database. It involves the use of a connection manager that is responsible for maintaining a list, or pool, of available connections for a given connection string. Several pools exist if different connection strings ask for connection pooling.

Post Your Answer
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.

Let`s Connect