Tory,
Pardon me for being stubborn, but I can't imagine why anyone would want to, or need to, page through 100 million records!!! Even if you only need a couple of pages worth (and not all 100 million), I think it'd be much easier to have the user select some criteria from which to choose and narrow down the rows to be displayed.
~~Bonnie
>I'm just wondering if anyone has any input on what the best practice would be for data paging within the framework. In my case it's for a windows forms application. I'm also dealing with over 100 million records in several tables so it's rather important. I've read an interesting article relating to ADO.Net data paging located at:
>
http://www.codeproject.com/aspnet/PagingLarge.asp>
>Unfortunately none of the paging methods described in that article are all that elegant. As a matter of fact I believe the most performant one as described by the author has a serious flaw in that it uses ROWCOUNT. I believe using ROWCOUNT in this manner has serious server wide implications. I know it doesn't stay within a given scope well although I don't know if it effects the entire server or just a given user etc. Anyways I thought I would get the opinion of this audience as to the best general method for use with the MM.Net framework or perhaps an alternative method.
>
>Any insight would be greatly appreciated.
>
>By the way... I'm moving this thread from the ADO.Net category to here as I feel it's a bit more appropriate. Please excuse the mistake as I'm new to this forum and it takes some getting used to. Unfortunately I have no way to delete the other message but perhaps that's just as well. It really applies to both after all. It also gives me the opportunity to elaborate a bit.