[dba-SQLServer] Paging through 1.5 million records in chunks of ~25,000 records...

Salakhetdinov Shamil mcp2004 at mail.ru
Wed Jun 15 02:25:21 CDT 2016

 Hi All --

I have to implement paging in an MS SQL database's one table through its ~1.5 million records in chunks of ~25,000 records in four views/sort orders both ASC and DESC iow total 8 views.
This is a desktop application.


Cast(ROW_NUMBER() over (ORDER BY [{{SortFieldName}}] ASC) as int) RowNumber

and then applying WHERE clause to the dynamic RowNumber field is prohibitively time consuming.  
What approach would you propose based on your own experience?

Thank you.

Салахетдинов Шамиль

More information about the dba-SQLServer mailing list