Bookmark: ASP.NET Performance Techniques
Scott recaps Rob Howard's 10 tips for writing high performance web applications and adds some interesting info on pagination.
Returning multiple recordsets is high on my list of optimizations. It's also one of the reasons I don't like MySQL. As much as possible, open the connection, get only the required data you need for the page, and then close the connection.
That link sends me to a login page... am I missing something?
ha! good catch... I copied the wrong URL. The links have been updated to point to the right places.