we want to put a 15k * 20k table in grid. We just virtualize the Row data(we read whole record each time). But it is still very slow. So we suspect the Grid create all the cell for each record even the cell is not displayed on the screen.
Could you give us some advices on how to improve the performance?
Hi Sam,
Yes, that's what we have to do. And by reverse-engineering the source code and use reflection to help xamdatagrid a little bit, we can only push it to 12 seconds to load, which is still too long. Please help to see if there is anything we can do to accelerate it, thanks.
I would like to clarify some of the informaiton to find out whether this is a performance issue or expected behavior. If I understand you correctly you are generating 20000 columns with 15000 rows. Correct me if I am missunderstaning it.
Thank you,
Sam
Hi sgrignola,
A benchmark for the most simple kind (least styled) will be very helpful for us. Performance is on the top of our wish list thus we'd like to hit the limit of XamDataGrid. Many thanks.
It's quite hard to give you a benchmark, I use custom styles for editors and cellvaluepresenters so it depends on how the users choose to setup their grid (the range goes from a basic presenter with only a contentpresenter to a "full" presenter with foreground/background/font/... different for every cell)
Could you please let us know how many fields could you load in a certain amount of time? Just want to have a reference so that we know where we are now. Thanks!