You would likely get better performance if you use a virtual grid. A virtual grid does not hold any data. All data is supplied to the grid from an external data source on demand. When the grid needs a particular cell, say to draw it, it asks the external data source for that value. Since no data is actually loaded into the grid, there is virtually no limit imposed by Essential Grid on the number of rows and columns you can have.
Refer the browse samples for Virtual grid performance:
1.There are two ways to display sorted data in the virtual grid:
- The simplest way is to sort the underlying datasource. If your datasource is something that supports sorting (like a DataView or some other IBindingList objects that supports sorting), then you can apply the sorting on your datasource. It will physically rearrange the external datasource so that the sorted data is displayed with no changes to the QueryCellInfo.
- The second option would be to create some sort of index array during your sort where the array tracks in some manner the relationship between the unsorted data and the sorted data. Then in your QueryCellInfo handler, you would use this array to get the proper reference for the requested row.
2.you can use the DataSource, To populate the grid without assigning the RowCount/ColCount.
3.Refer to Documentation more details:
Essential Grid -> Windows Forms -> Basic Concepts -> Virtual Grid & Tutorials -> Virtual Grid.
Refer to the sample for Virtual Grid Sorting [ 100,000 Records ]
Let me know,if you need futher assistance,