I read this article:

http://www.codeproject.com/aspnet/PagingLarge.asp

I'm developing a multi-user community site which will host many hundreds of thousands of users. The paging will be implemented in search pages (user search), mailbox, etc etc.

What are your thoughts on this article? I was told that using temp table would actually be more scalable, but the author of the article seems to rule it out completely.