Research And Implementation Of Pagination Strategy Based On .NET Platform

With the rapid development of information technology, computer, database and network have already become the three pillars of information systems. At the same time, customer's requirements to the system performance are also getting higher and higher with the popularity of database application systems. How to maximize the performance has already become a problem that calls for immediate solution.At the development process of web database application systems based on SQL Server, the query and pagination of data is one of the necessary functions. Give attention to two or morethings both the function of pagination and the performance of web systems, this paper investigates two levels of pagination strategy: one is Database Optimum Design, mainly on the design of index, sort and filter; another is Pagination Design, mainly on two pagination patterns of web and database.Based on the two levels, the paper elaborates on the implementation of the strategy, which mainly includes there levels as follows:(1) Bring up three general algorithms for pagination: SDA, TOB and R_N.(2) Design and Implement a kind of web system based on the .NET platform with four programming characteristics, derived from C#, ASP.NET, Transact-SQL and ADO.NET.(3) Make a comprehensive assessment to the three algorithms based on the web system and Give the assessment conclusions with illustration in the meantime: when DBMS is SQL Server 2000, the TOB algorithm is better; when DBMS is SQL Server 2005, the R_N algorithm is better. And the conclusions also suggest that the algorithms which adopt the pagination pattern of database have good pagination efficiencies, and they can meet most of the pagination demands.