| ComponentOne True DataControl 8.0 > Improvements Over Standard ADO Data Sources > Reused (pooled) Connections |
This improvement only concerns True DataControl in comparison with the standard Microsoft ADODC control. Using Visual Basic DataEnvironment or coding for ADO Recordset objects, you can control ADO Connection objects that the recordsets belong to.
With ADODC control, however, each control creates its own Connection object, which is a performance-heavy operation for most databases. Connection objects proliferation leads to considerable performance degradation and other problems (see Microsoft Access problem with refreshing recordsets from database).
You don't have this problem with True DataControl, since it uses connection pooling and also allows you to take full control over connections with the SourceConnection property. The connection pooling feature ensures that different controls having identical ConnectionString settings normally use only one single connection (some other conditions apply for pooling to take effect, see Connection Pooling for detail).
Connection pooling is unavailable in True DataControl Lite.