本文已被:浏览 1502次 下载 3265次
Received:May 14, 2012 Revised:June 10, 2012
Received:May 14, 2012 Revised:June 10, 2012
中文摘要: 讨论了在数据库服务器端应用存储过程的方法来实现海量数据的分页, 重点讨论分页存储过程的设计思想、实现方法以及在通过ADO.NET 命令对象调用存储过程的方法. 通过该方法, 减少了海量数据查询时的网络流量, 提高了系统的效率.
Abstract:This paper describes the paging of massive data with stored procedures in the database server, focuses on the design ideas and implementation methods of stored procedures for data paging, and their calls by ADO.NET command object. The method greatly reduces the network traffic when the massive data queries, and improves the efficiency of the system.
keywords: massive data paging stored procedure ADO.NET SQL
文章编号: 中图分类号: 文献标志码:
基金项目:
Author Name | Affiliation |
HUANG Long-Jun | Department of Computer Science, Shaoxing University, Shaoxing 312000, China |
Author Name | Affiliation |
HUANG Long-Jun | Department of Computer Science, Shaoxing University, Shaoxing 312000, China |
引用文本:
黄龙军.应用存储过程实现数据分页.计算机系统应用,2012,21(12):186-189
HUANG Long-Jun.Implementation of Data Paging with Stored Procedure.COMPUTER SYSTEMS APPLICATIONS,2012,21(12):186-189
黄龙军.应用存储过程实现数据分页.计算机系统应用,2012,21(12):186-189
HUANG Long-Jun.Implementation of Data Paging with Stored Procedure.COMPUTER SYSTEMS APPLICATIONS,2012,21(12):186-189