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 ...
Get Delphi for .NET Developer’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
