| 利用SQL Server存储过程提高在线考试系统的性能 |
| |
| 引用本文： | 丁苹媛,宋扬,袁中臣,魏宝武.利用SQL Server存储过程提高在线考试系统的性能[J].微型机与应用,2011,30(22):7-9. |
| |
| 作者姓名： | 丁苹媛 宋扬 袁中臣 魏宝武 |
| |
| 作者单位： | 沈阳工业大学工程学院,辽宁辽阳,111003 |
| |
| 摘 要： | 利用SQL Server作为数据库管理平台开发高校通用计算机在线考试软件系统时,由于数据量较大,最应关注的是软件系统的运行速度、性能和可维护性等指标。如果采用常规的程序设计方案,会造成网络通信数据量大、业务逻辑处理速度慢、系统运行效率低等问题。为解决这些问题,软件系统中相关业务逻辑设计采用存储过程的方法实现,大大减少了网络流量,提高了系统的性能和可维护性。
|
| 关 键 词： | SQL Server 在线考试 网络流量 存储过程 |
Using SQL Server stored procedures increase performance of online exam system |
| |
| Ding Geyuan,Song Yang,Yuan Zhongchen,Wei Baowu.Using SQL Server stored procedures increase performance of online exam system[J].Microcomputer & its Applications,2011,30(22):7-9. |
| |
| Authors: | Ding Geyuan Song Yang Yuan Zhongchen Wei Baowu |
| |
| Affiliation: | Ding Geyuan,Song Yang,Yuan Zhongchen,Wei Baowu(Project Institute,Shenyang University of Technology,Liaoyang 111003,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | SQL server online exam network flow stored procedure |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
