交通工程管理系统的数据库性能优化措施

主要以EMIS系统数据库性能优化为出发点，参照目前网络数据库开发考虑的因素如操作系统、数据库结构、应用程序等，围绕数据库连接，查询语句的执行效率等讨论了该系统性能优化的几个主要方面，并提出了相应的改进方法：优化查询语句；使用连接池；适当数据冗余。由此了解如何分析和改进数据库性能、如何维护一个性能满意的数据库。

The Method for Optimizing Database of the Project Management Information System

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.