考虑到Record的大小，在GridView中实现分页的最佳过程是什么？ [英] What is the best procedure to implement paging in a gridview considering size of Record?

问题描述

我有一个在sq服务器数据库有超过100万行的表。
我需要在一个asp.net页面中用分页显示这些数据。

由于记录数量较大，我需要提高页面显示数据，实现分页。

请问我应该遵循什么程序来实现分页？

解决方案

有很多方法可以实现，但一般概念是按需提取。当显示第一个页面的前50个时，您不需要获取记录200到250.

有一些非常智能的实现，它们混合使用Ajax以改善用户体验，也提前和/或后台提取，例如抓取100页面大小为50，以便查看下一页更快。

您可能想从更直接的开始， Google 应该可以找到。

一对夫妇在这里：

大量有效分页在ASP.NET中的数据

使用SQL Server 2005和Microsoft企业库进行有效数据分页

I have a table in sq server db having more than 1 million rows. I need to show those data in a gridview with pagination in an asp.net page.

Since the record amount is larger I need to boost performance of the page for showing data, implementing pagination.

What procedure should I follow to implement pagination?

Please help.

解决方案

There are a number of ways to do it but the general concept is "fetch on demand". You do not need to fetch record 200 to 250 when displaying the first 50 in the first page.

There are some very intelligent implementations which mix Ajax in to improve user experience and also look-ahead and/or background fetching, e.g. fetch 100 for page-size of 50 so viewing next page is faster.

You might want to start from more straightforward ones, Google around you should be able to find.

A couple here:
Effective Paging with Large Amount of Data in ASP.NET
Effective Data Paging Using SQL Server 2005 and Microsoft's Enterprise Library

这篇关于考虑到Record的大小，在GridView中实现分页的最佳过程是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！