Power Load Management System-based Database Performance Improvement

Along with the information accretion of modern information application system, database has been the basis and core of computer information system, and computer application system. For majority of database applications, the system performance shall descend after running for a period. It mainly results in database design, application, database server etc... So the tuning and optimizing based on database system can economize the cost of system running, ensure the database running stably, enhance the running efficiency of the system and is extremely important to the regular running of the whole system.This topic is mainly expatiating the application of database performance tuning in the upgrade project TY-EIM electric power load control system belonged to PingGao Group's from these aspects: database design tuning, client application tuning and server performance tuning etc. With the transaction quantity increasing, data expanding rapidly, system performance decreasing, it is not endurable for a long time to query. For these reasons, this system makes these tunings: using database opposite standardization, increasing redundancy row. It can decrease the number of tables and the query connection, improve query speed. By using reasonable index, SQL query optimize and stored procedure, it can optimize the query path, enhance query efficiency. By tuning the application it can avoid a great of low efficiency nesting query, ensure database system running high efficiently, remove bottle necks and save system recourses.After testing the tuned system, the query speed on client has been enhanced evidently in TY-EIM electric power load control system, the query responding timer educed from 40 seconds to 10 seconds per 21060 lines. In addition, the average of resource engross rate in database server reduce from 75% to 55%,so it is up to the stable standard and the system integrated performance enhanced evidently.