短学期实践管理系统的性能优化设计

Performance Optimization Design of Short Term Practice Management System

短学期实践管理系统的设计与开发是为了实现高校教务处在短学期阶段对学生实践活动的在线管理。系统开发设计的难点和重点不在功能上,而在系统的高并发、可扩展等非功能特性的实现。笔者首先简单介绍了系统的功能需求,然后详细介绍了系统性能优化方案,采用了数据库连接池、数据库分表、表的动态创建等技术。通过实验证明,这些方法使得查询、更新操作效率得到较大的提升。

The design and development of the short term practice management system is to realize the online management of students'practice activities in the short term of the Academic Affairs Office of the university.The difficulties and emphases of the system development and design are not the function,but the realization of the non functional features such as high concurrency and scalability.The author first introduces the functional requirements of the system,and then introduces the system performance optimization scheme,using database connection pool,database tables,tables and other dynamic creation technology.The experiments show that these methods can improve the efficiency of query and update.