Research Of Database Performance Optimization In Large Scale Application System

Database is widely used in network information gathering system. The data volume is much bigger. The data process is more complex and the requirement of the database performance is getting higher than before. How to take full advantage of the hardware and software resource to improve the database performance becomes a hot topic. How to optimize the performance of database application system is mainly discussed in this thesis. The work of performance optimization of database application system is extremely complex. It includes mainly operating system, application procedure, and database, network optimization and so on. Therefore, we need to consider all the possible factors comprehensively in the system optimization process.The primary cause of the performance question is whether reasonable optimization for web server and the database server system. How to discover and diagnose the performance question of database application system by testing the application and the database system is introduced in the thesis, and we analyze the performance effect made by these questions in detail.The content of Oracle database optimization is complex. It mainly includes the memory optimization, I/O optimization, and database objects optimization and so on. The application program optimization mainly includes several important aspects, code optimization, how to use the database connection pool and to optimize the SQL sentence. The highly effective database connection pool makes data exchange between the application procedure and the database steadier and more effective, and reduces the response time of the system. The SQL sentence optimizes may reduce the system response time, enhance the utilization ratio of the CPU and reduce the expense of the system resources (memory, I/O and so on).College Enrollment Network Gathering Voluntary System is well known for the large scale data volume, the high requirement for data security, centralized access and so forth. This paper takes College Enrollment Network Gathering Voluntary System for example, focuses on Oracle database memory optimization, disk optimization, inquiry method optimization and the database connection pool optimization, and provides a good reference for the optimization of the large scale database application system.In addition, according to the special requirement of system, we complete the test procedure for the system, and test the inquiry method optimized and the database connection pool optimized by utilizing the test procedure and the J meter. By testing, we know that the system optimized improves the performance and meet the system requirement.