应用存储过程实现数据分页

Implementation of Data Paging with Stored Procedure

讨论了在数据库服务器端应用存储过程的方法来实现海量数据的分页,重点讨论分页存储过程的设计思想、实现方法以及在通过ADO.NET命令对象调用存储过程的方法.通过该方法,减少了海量数据查询时的网络流量,提高了系统的效率.

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.