摘要
主要以 EMIS系统数据库性能优化为出发点 ,参照目前网络数据库开发考虑的因素如操作系统、数据库结构、应用程序等 ,围绕数据库连接 ,查询语句的执行效率等讨论了该系统性能优化的几个主要方面 ,并提出了相应的改进方法 :优化查询语句 ;使用连接池 ;适当数据冗余。由此了解如何分析和改进数据库性能、如何维护一个性能满意的数据库。
In order to optimise the EMIS Web database,factors involving in present creation of website databases such as operating system,database structure and applications were analysed.According to the results,two methods in optimisation of its functions were discovered.Furthermore,we gave their modified methods including optimising the SQL,using database connection pool and properly making of redundant data.This article can help to learn the way of how to analyse the functions of a database,optimise them and further maintain their perfect status.
出处
《武汉理工大学学报》
CAS
CSCD
2004年第6期82-84,共3页
Journal of Wuhan University of Technology
基金
湖北省交通科技攻关项目 (2 0 0 35 70 )
关键词
SQL
连接池
优化
SQL
database connection pool
optimize
