蹩脚的Access分页语句

数据量大了，必然导致性能降低，但是又没找到更好的方法----囧

DECLARE @PageSiz INT, @CurPage INT 
SET @PageSiz = 10  
SET @CurPage = 28 
select top (@PageSiz)  *  from JS_ARTICLE
where [GUID] not in(
select top ((@CurPage-1)*@PageSiz) [GUID] from JS_ARTICLE where  ArticleID not in (33,36,39) and ClassId='7f57a331-1e17-46ef-aaea-a6c0d1f0f0c7' order by ArticleID,[GUID])
and ArticleID not in (33,36,39) and ClassId='7f57a331-1e17-46ef-aaea-a6c0d1f0f0c7' order by ArticleID,[GUID]

转载于:https://www.cnblogs.com/Denny_Yang/archive/2011/03/04/1970614.html