用COM+实现高效连接池

Implement efficient connection pool with COM+

为解决在大型管理信息系统中存在的数据库连接影响系统性能的问题,运用连接池技术给出了一种有效的解决方案。在描述连接池的一般原理和当前的实现技术基础上,给出应用COM+(ComponentObjectModel+)的对象池机制和运用VC++提供的ATL(ActiveTemplateLibrary),建立了一个高效的连接池。通过连接池可以避免数据库连接对象频繁的创建和销毁带来的系统开销,有效地提高了系统性能,充分体现了多层结构的优点。实际测试结果表明,当活动连接超过200时,通过连接池可以很大程度上提高数据库的响应效率,尤其对于涉及多个连接的分布式事务,提交的准确性和效率都能提高1倍以上。连接池还可以通过限制活动连接的数量,避免因为连接数量过多而造成系统崩溃现象。

To solve the problem that database connection generally influences the performance of large-scale management information system, an efficient solution by using connection pool technology was given, the general principle and implementation techniques of connection pool was given, the implementation of an efficient connection pool was given by using the object pool of COM+ and the ATL provided by(VC++ .) Connection pool can avoid the system spending brought by the frequently creating and destroying of database connection object and can improve the performance of whole system efficiently. Connection pool also presents the advantages of multiple tiers system. Practical test results show that connection pool can permanently improve the database's response efficiency when the number of active connection exceeds 200. By using connection pool, the validity and efficiency of distributed transactions that may contain some active connections can be improved more than two times. By limiting the number of active connections, system crashes owing to too many connections can be prevented.