unvell
[WPF] What is the fastest way to load data
Hello!
Thank you for your very nice Control for .NET.
I am trying to initialize a large Worksheet (dimension 1,000,000 x 2) with data already loaded in memory.
Can I ask what is the most efficient way to load the data?
For now I am handling the Initialized event of the Control that hosts this Spreadsheet and setting the values one by one
_Worksheet = _ReoGrid.CurrentWorksheet;
_Worksheet.Resize(1048576, 2);
_Worksheet.SuspendDataChangedEvents();
for (var row = 0; row < Inputs.Count(); row++)
{
var Row = row;
_Worksheet[Row, 0] = x[row]
_Worksheet[Row, 1] = y[row];
}
_Worksheet.ResumeDataChangedEvents();
where x and y are my values. This takes a lot (like 14s), so I wonder if there is a better way I cannot find in the documentation.
Thank you very much!
Thank you for using ReoGrid!
Unfortunately, the open-source version of this library does not include advanced features for handling large datasets efficiently.
Starting from version 4 of ReoGrid (available as a closed-source commercial edition), we introduced a new feature that supports lazy loading from a data source. With this feature, cell data is loaded only when it's displayed or accessed, significantly improving performance. During initialization, only the first 20 rows × 10 columns are loaded by default, making the startup process very fast regardless of the overall dataset size.
If you're interested, feel free to contact us for more details about the Enterprise edition.
https://reogrid.net/purchase (only ENTERPRISE edition support it)
