Web数据库分页浏览方法性能分析  

Performance Analysis of Web Database Paging Browse Methods

作　　者：王博[1] 任涛[1] 

机构地区：[1]西安理工大学自动化与信息工程学院,陕西西安710048

出　　处：《现代电子技术》2006年第10期68-70,共3页Modern Electronics Technique

摘　　要：随着互联网的发展,Web数据库的应用越来越多,在Web页面中实现数据库记录的分页显示是一项复杂而又实用的技术。Web数据库分页有基于ADO的分页和存储过程分页2种方法。从Web数据查询特点出发,对这2种方法的性能进行了分析,并且着重介绍了存储过程分页的实现方法以及表变量在存储过程中的应用,最后对这2种Web数据库分页浏览的方法进行了测试和比较。结果表明,利用存储过程分页可以有效地提高Web数据访问的效率。Along with the development of Internet, application of Web database is more and more. In the Web page, carrying out the paging of database record is a complicated and practical technique, the Web database paging has two kinds of methods： ADO paging and storage procedure paging. According to the characteristics of Web database query,this paper analyzes the performance of these two kinds of method,and emphasis on introducing the approach of storage procedure paging and the application of table variable in storage procedure. At last, wc make a test on these two different methods to Web database paging browse,and the result of the test indicates that storage procedure paging is a good way to improve efficiency of Web data access.

关 键 词：Web分页 ADO 存储过程 表变量 

分 类 号：TP393.092[自动化与计算机技术—计算机应用技术]