【摘要】 为实现数据库性能优化,在分析数据库管理系统(DBMS:DataBaseManagementSystem)执行查询的工作原理的基础上,研究了两种重用查询计划的方法:缓存计划的存储过程、缓存和重用SQL(StructuredQueryLanguage)语句,并结合实例介绍了两种方法的创建和使用。根据作者的实际开发经验和对两者的对比分析,提出了优化数据库性能的可行建设方案:在考虑提高系统的可维护性、可扩展性和减轻网络负担时,宜多采用缓存的存储过程;而更多考虑降低系统管理的复杂程度和减少缓存占用时,则多采用缓存和重用SQL语句。在实际运用中取得良好效果。更多还原

【Abstract】 To optimize database performance based on analyzing the principles of DBMS(Data Base Management System) querying, two RQP(Reoccupying Query Plan) methods are studied: storeprocedure and reoccupying SQL(Structured Query Language)sentence.Based on the presented example, the usages are given. According to developing experiences and constrast analysis, a feasible scheme is presented to optimize database performance: storeprocedure is adopted to add the system remaintence and expansibility and reduce the system’s burden. And reoccupying SQL sentence is adopted to reduce the system’s complexity and occupancy of system’s buffer. A perfect result is obtained in the actual application.更多还原