Help, I'm trying to display 3 million records in a datagrid inASP.NET

[spoon2481]

I'm trying to display 3million records in a datagrid in ASP .Net and I juct can't figure out any solution. I tried a datareader but then I woun't be able to page back and forth because its a foward only curser I also tried using a server side cursor but that only took 20min to make. I know I'm not going to be able to store the 3million in memory but I need some kind of way to scroll through the records back and forth.

 

[MarkSweetland]

Not that I'm being critical here, but why would a user want to page back and forth through 3 million records? Are they looking for something in particular? Can you offer them a search solution that would pare it down to a manageable recordset, or help them find what ever it is they are looking for?

Don't get me wrong, but I, for one, would not like to wade through that much information to find anything...



Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[zemp]

I agree, a search mechanism of some sort is a better solution.

Think of the time involved in paging 3 million records. At 100 records a page and 5 seconds to look through a page it would take a user around 40 hours to look at 3 million records.

Thanks and Good Luck!

zemp