Efficiently Paging and Sorting Large Result Sets with SQL Server 2000

Question

User-2090449847 posted

I've successfully implemented custom paging with a GridView following the steps in Scott Mitchell's tutorial and using the stored procedure from this excellent article, A More Efficient Method for Paging Through Large Result Sets.  (I had to add a line to the sproc that adds 1 to the startRowIndex).  The GridView paging speed for my 800,000+ record table is amazing!

Now if only I could get sorting to work...

I've tried to take Scott's tutorial on Sorting Custom Paged Data, which is aimed at SQL Server 2005, and modifying it to work with the stored procedure mention above, but so far I have had no luck.  Please, help me figure out custom sorting with SQL Server 2000.  Thanks!

Answer 1

User-2090449847 posted
Has anyone figured out sorting a custom-paged GridView using SQL Server 2000?

Answer 2

User-2090449847 posted
I found the answers I needed from this article on Paging Large Resultsets.  I've decided to abandon the RowCount method in favor of the slightly slower Cursor method, which allows easy sorting of columns that don't contain unique data.