大家帮忙测试一下ms分页控件(SqlPager)中分页查询的效率如何。
以下是分页查询语句
SELECT * FROM
(SELECT TOP {0} * FROM
(SELECT TOP {1} * FROM ({2}) AS t0 ORDER BY {3} {4}) AS t1
ORDER BY {3} {5}) AS t2
ORDER BY {3}
其中:
{0}为要取的记录数, 如20
{1}为包含要取的记录数的总数, 如取要取80-100, 则此数应为100,
{2}为查询语句,
{3}为排序字段
{4}{5}为排序方式,必须相反
以下是文章和下载地址:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/pagercontrols.asp
请有条件的朋友测试一下在记录数为1000, 10000, 100000,
1000000下的查询速度.