Bank Collection Performance Pay System Optimization

The Receipt and Payment System is an important business subsystem ofChina National Advanced Payment System which docks with Bulk ElectronicPayment System seamlessly and runs uninterruptedly within7*24hours.During the beginning of the system, the amount of users and data is small. Sothe system mainly targets is the improvement of function and system flow, theinfluence of massive amounts of data is not taken into consideration, now thesimple query of the system may take longer than expected, the efficiency ofsystem is low too. Aiming at this problem of the system, there is a need forsystem to transform and upgrade. This paper mainly tells how to optimize thesystem in three major areas: memory-adjust, disk I/O adjustment and SQLefficiency to reach the goal that ensures the system runs safely, steadily andefficiently and ensure users have a pleasant experience finally.This paper mainly studies the performance optimization of The Receipt andPayment System based on web applications, analyzes deeply some possibleproblems what influence the performance of web application system, theseproblems first cover the hardware configurations of server, the parameterconfigurations of database, disk I/O adjustment, SQL efficiency and so on,thencover database principle of oracle, database design and SQL optimization. Onthis basis, I discover that there are some performance issues in this system onserver memory, database design and SQL efficiency when I study and analyzethe low response of the Receipt and Payment System by looking up a lot of data.Firstly, this paper makes use of Fault Tree Analysis to build a Fault TreeAnalysis model of the Receipt and Payment System over taking into accountseriously. Secondly, According to this model, makes several rectifications insystem memory, oracle database parameter, Disk I/O and SQL efficiency.Finally, by analyzing and comparing the execution plan and statistical analysisof statement when adjust before and after to determine whether the optimizationeffects. By constantly adjusting, makes sure users will be satisfied with theresponse speed to achive the goal that solve the existing problems of system. This paper through the study, analysis and solve the problem of the Receiptand Payment System,both realized a performance improvement of the existingReceipt and Payment System and provided a reliable basis for the future, thus,created a safer, faster and kinder user environment.