Connection Pooling allows connections to be reused once they are no longer used. ADO supports Connection Pooling and, by default, it is on. Connection Pooling is one of those features which, at first sight, appears to be obvious but with a little investigation reveals how much there is to it. We look at disabling connection pooling, setting its timeout, and controlling pooling through the registry and through the connection string. Cloned Recordsets .
ADO allows recordsets to be 'cloned'.
Such cloned recordsets are connected to the same original data but have a separate set of status information e.g. record pointer. Cloned recordsets are primarily useful for black box programming but they have other less obvious uses. This section shows how to clone recordsets, the restrictions on cloning and the uses to which cloned recordsets can be put. Streams in ADO serve the same purpose as IStream in COM and TStream in Delphi. They provide a means to read and write a stream of data.