Web数据库性能调优(英文)

Performance Tuning for Web Based Databases

提出了一种基于Web数据库系统设计、实现和性能调优的新方法,该方法包括由RDBMS配置优化、应用模式设计优化和编程优化。通过内存、分段、磁盘参数和时间相关参数的优化可以设置一个好的RDBMS运行环境。在编程时,通过减少与后台连接和断开操作、建立和使用索引、多用存储过程和优化SQL语句可以优化系统性能。在应用设计时,通过优化应用逻辑和降低规范化可以大大地改善系统性能。

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.