I am evaluating the use of DataGrid for large sets of data. I was wondering if the are some benchmarks and/or pointers on how to best handle large data in the grid.Specifically,
– Is it possible to handle initial loads of about 400mb of read-only records and the preferred efficient way of doing so?
– If we don’t need modification, only filtering and searches – is it better to utilize tables vs. grids in this case, or the tradeoff is negligible?
– Is there an example showing how a virtual datasource on a grid works in terms of improving performance on a large initial load.