C # Datasets, paging and large amounts of data

Question

I want to show a large amount of data in a dataset, 100,000 records of approximately 10 columns, this consumes a large amount of RAM 700 MB. I also tried using paging, which reduces this by about 15-20%, but I don't really like the Previous / Next buttons when using paging. I am not writing data to disk at the moment, should I be? If so, what is the most common method? Data should not be stored forever only during viewing, then a new query can be launched and more than 70,000 records can be viewed. What is the best way to continue?

Thanks for the advice.

Answer 1

, , , (listview), , . .

XML , , , .

Answer 2

, . , . , , , :

• , , 700 - . . , . : .
• , .
• , , 700 . , . , ( ) .

Answer 3

... , .NET .

Answer 4

, .

ASP.NET? Windows?

I personally found that using a customizable pager setting (for management, the following previous links) and swapping at the database level would be the only possible way to get maximum performance, just get the necessary data ....

Answer 5

implement swap in SQL if you want to reduce memory