Web数据库性能调优_英文_.pdf

第31 卷 第3 期 电 子 科 技 大 学 学 报 Vol.31 No.3 2002 年6 月 Journal of UEST of China Jun. 2002 * Performance Tuning for Web Based Databases Wu Yue Qiu Huizhong Yu Shui Yu Yuanhui (College of Computer Science and Engineering, UEST of China Chengdu 610054) Abstract The traditional C/S database systems often suffer from the poor performance in the environment of Web applications because the number of users and the frequency or the times of accessing to a Web application are very difficult to be determined in advance. In this paper, a new method is proposed for the design, implementation and tuning of the Web based database system. This approach focuses on the configuration of RDBMS, the design of application model, and programming. By optimization on memory, on fragmentation, on disk parameters and on time related parameters, a better running environment of RDBMS can be set up. By reducing the CONNECT and DISCONNECT operations, creating suitable indexes, using more stored procedure and optimization on SQL, good performance can be got at programming step. By optimization on business logic and denormalization, the system performance can be greatly improved at design step . Key words performance; optimization; Web database; tuning Web数据库性能调优* 吴 跃** 邱会中 余 水 余元辉 ( 电子科技大学计算机科学与工程学院 成都 610054) 【摘要】提出了一种基于Web数据库系统设计、实现和性能调优的新方法，该方法包括由RDBMS配置优 化、应用模式设计优化