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,

Scott

 

Published Wednesday, March 22, 2006 10:41 PM by ScottGu
Filed under: , ,

Comments

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

Thursday, March 23, 2006 4:08 AM by Steve
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.... :(

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

Tuesday, August 1, 2006 5:48 AM by bluedee
how to implement it using sql server 2000? thanks

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

Tuesday, January 9, 2007 10:35 AM by Matt

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.