几种分页方案详尽分析---10万条记录实例测试

测试表名： QC

测试记录数：约10万条

测试环境：SqlServer2008

 

器材(QC)表

 

记录条数：103997

select COUNT(*) from QC     执行结果 103997

 

分页方案一：(利用Not In和SELECT TOP分页)

 declare @currtime1 datetime set @currtime1=GETDATE() print @currtime1 declare @pagesize int declare @currentpage int set @pagesize=10 set @currentpage=5000 select top 10 * from QC where (QC_ID not in (select top (@pagesize*(@currentpage-1)) QC_ID from QC order by QC_ID)) declare @currtime2 datetime set @currtime2=GETDATE() print @currtime2 print DateDiff(Ms,@currtime1,@currtime2) go

 

执行结果：