利用SQL Server存储过程提高在线考试系统的性能

Using SQL Server stored procedures increase performance of online exam system

利用SQL Server作为数据库管理平台开发高校通用计算机在线考试软件系统时,由于数据量较大,最应关注的是软件系统的运行速度、性能和可维护性等指标。如果采用常规的程序设计方案,会造成网络通信数据量大、业务逻辑处理速度慢、系统运行效率低等问题。为解决这些问题,软件系统中相关业务逻辑设计采用存储过程的方法实现,大大减少了网络流量,提高了系统的性能和可维护性。

Using SQL Server being database, management platform to develop university general online exam system, concern is running speed, performance and maintainability of software system because large data. It will cause the large of network communication, business logic slow processing speed and low operation efficiency with normal program design. To solve these problems, related business logic of software system is realized using the method of realization stored procedures. It reduces network flow greatly and improves the performance and maintainability of the system.