A performance optimization based on stored procedure in RDBS project

When system encounters large amount of data, complex transaction rule and high system security required in relationship database system project, the efficiency, maintainability, data integrity and reliability are eagerly to be solved. Using stored procedure can improve the questions mentioned above. By taking Query Service System of Teaching Affairs as example, this paper analyzes the meaning of stored procedure in database and key problem of Application strategy, illustrates query optimization method based on stored procedure, and also presents some other approaches to improve the performance of RDBS. Finally, the performance evaluating result before and after the optimization is provided, which shows the method is practical and effective.