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.