120 days of 1200 hours of pass-through for junior students. NET (12) about efficient paging

Pagination rules

Method 1 (most commonly used):

Start: (pageIndex-1) *pagesize+1 end:pageindex*pagesize

SELECT * FROM
(select *,row_number () over (order by Id Desc) as RowIndex from Tb_person where RowIndex) as Tb_new
where RowIndex between (@pageIndex-1) * @pageSize +1 and @pageIndex * @pageSize

Method 2 (fast on front and back page queries) How many rows to fetch across

Select Top (@pageSize) *

From Tb_news where ID not exits in

Select Top (@pageIndex-1) * @pageSeze * from tb_news;

120 days of 1200 hours of pass-through for junior students. NET (12) about efficient paging