OA系统性能优化及提高数据检索效率方法研究

摘要

针对项目管理系统中数据交错导致数据检索时间长,系统性能差的问题,提出两个系统优化的方案:添加索引和添加中间表.最终通过建立中间表,提前将有用数据存储,使用时直接从中间表中检索数据,有效的降低检索时间,提高系统运行效率.运用中间表的方式,对系统性能的提高在60%以上.%Aiming at the problem of long data retrieval time and poor performance of the data in the project management system, two system optimization schemes are put forward.Through the establishment of intermediate table and in advance of the useful data storage, the intermediate table is used directly to retrieve data.The search time is effectively reduced, and the efficiency of the system is improved.The performance of the system is improved by more than 60% in the middle of the table.