i want to display 1000000 records in a grid view at a time

Hi akash singh,

If you can't fit your entire data set in memory, then you need a buffering scheme. Rather than reading just the amount of data needed to fill the DataGridView in response to CellValueNeeded, your application should anticipate the user's actions and read ahead. So, for example, when the program first starts up, it should read the first 10,000 records (or maybe only 1,000 or perhaps 100,000--whatever is reasonable in your case). Then, CellValueNeeded requests can be filled immediately from memory.

As the user moves through the grid, your program as much as possible stays one step ahead of the user. There might be short pauses if the user jumps ahead of you (say, wants to jump to the end from the front) and you have to go out to disk in order to fulfill a request.

That buffering is usually best accomplished by a separate thread, although synchronization can sometimes be an issue if the thread is reading ahead in anticipation of the user's next action, and then the user does something completely unexpected like jump to the start of the list.

16 million records isn't really all that many records to keep in memory, unless the records are very large. Or if you don't have much memory on your server. Certainly, 16 million is nowhere near the maximum size of a List, unless T is a value type (structure). How many gigabytes of data are you talking about here?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

priya Avanigadda11y ago
Hii Akash Sir,U can do by using paging with dropdown then u can display 1000000 records in one page.But while loading it wil take time to display.
0
akash singh11y ago
wim acctly i want to export this grid view record into excel file... understand... so this is not an insane request
0
Wim Sturkenboom11y ago
As I said in your other thread, you're requirement is insane. Nobody in his sane mind will scroll through 1 million records.
-2
Manish Kumar Choudhary11y ago
write simple select query
-1
akash singh11y ago
what is code....
0
Manish Kumar Choudhary11y ago
Hi akash singh,
If you can't fit your entire data set in memory, then you need a buffering scheme. Rather than reading just the amount of data needed to fill the DataGridView in response to CellValueNeeded, your application should anticipate the user's actions and read ahead. So, for example, when the program first starts up, it should read the first 10,000 records (or maybe only 1,000 or perhaps 100,000--whatever is reasonable in your case). Then, CellValueNeeded requests can be filled immediately from memory.

As the user moves through the grid, your program as much as possible stays one step ahead of the user. There might be short pauses if the user jumps ahead of you (say, wants to jump to the end from the front) and you have to go out to disk in order to fulfill a request.

That buffering is usually best accomplished by a separate thread, although synchronization can sometimes be an issue if the thread is reading ahead in anticipation of the user's next action, and then the user does something completely unexpected like jump to the start of the list.

16 million records isn't really all that many records to keep in memory, unless the records are very large. Or if you don't have much memory on your server. Certainly, 16 million is nowhere near the maximum size of a List, unless T is a value type (structure). How many gigabytes of data are you talking about here?
0