用连接池提高Servlet访问数据库的效率

Improving the Efficiency of Servlet Links to the Database by Using Connections Pool

作为应用十分广泛的服务器端程序,Java Servlet有着很多的优势。不仅多个请求可以共享公用资源,而且还可以在不同用户请求之间保留持续数据。不过随着数据库访问量的增大,传统的Servlet与数据库连接方式的效率下降十分明显。介绍一种充分发挥该特色的实用技术,即数据库连接池。实践证明:应用连接池技术可以大幅度提高数据库访问的效率,尤其是在多次数小规模的查询操作上表现尤为明显。

As a widely used server side data processing technology,Java Servlet has several advantages. By using this technology, public resources can be shared between requests, and continuing data can be retained between different users request. Although it is a powerful technology,it also has some disadvantages. For instance, with the developing access to the database, the efficiency dropped dramatically. In this paper we introduce a full play to the characteristics of the practical skills,database connections pool. It has been proved that efficiency can be improved by using database connections pool. It can be observed obviously in the multi- number of times small scale inquiry operations.