Efficient Data Paging and Sorting with ASP.NET 2.0 and SQL 2005

I posted two articles on doing efficient data paging with ASP.NET 2.0 and SQL 2005 earlier this year:

Scott Mitchell just posted two great articles discussing custom paging and the ObjectDataSource control even further, and includes SQL profile data and traces to quantify the performance gains you can realize from it.  You can read them here:

Definitely worth checking out!

Hope this helps,




  • Thanks! I wish I could use these techniques but our customers probably won't have 2005 for a few more years. Does anyone have a pointer to a best practices for SQL 2000?

    Basically, wondering if "TOP(PageSize) ASC of TOP(PageNum*PageSize) DESC" is the best way to do things. Also, I'm curious why they can't just provide a row range operation. Seems we'll never be able to avoid having to write one sproc per orderby.... :(

  • how to implement it using sql server 2000?


  • liggett78, thanks for the link to that excellent article! I'm finally able to efficiently sort my cutom-paged million-record table with SQL Server 2000. I decided to abandon the Rowcount method in favor of the slightly slower Cursor method mentioned in that article, which allows sorting on columns that aren't unique.

Comments have been disabled for this content.