Connection Pooling
When building data-driven applications, particularly distributed applications, connection pooling can be valuable. Consider distributed applications based on services that host database connections which get created and destroyed frequently. Having to reestablish a connection could drastically impact the scalability and performance. Although it might be fine for a few users executing many transactions, it would not be sufficient for many users executing few transactions.
Connection pooling is not a function of the .NET Framework, but rather made available by the .NET provider.
The function of connection pooling is to recycle previously opened connections, thus saving time when a new connection is requested. The reason for this ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access