OLE DB Provider Connection Pooling

  • Article

When an application such as Visual Basic or ActiveX Data Objects (ADO) opens a connection to SQL Server, the OLE DB Provider for Commerce Server opens a pool of connections that it initializes for performance reasons. However, it does not try to activate all of the connections at initialization time. The connection objects are created and placed in a “free” queue. When the OLE DB Provider for Commerce Server gets a request for a connection, it checks to see if there are any connections in an “idle” queue. If not, it acquires a connection from the “free” queue and uses it to connect to SQL Server.

Copyright © 2005 Microsoft Corporation.
All rights reserved.