To show data in my XamDataGrid, I am using a Datatable, that is bound to the XamDataGrid. This works fine.
While testing, I recognized the following problem:
As you can see in the picture below, I let the XamDataGrid show me the count of the rows of the second column.
Currently, there are about 1 million rows (I am testing worst cases), and when I check the box, to get the count, it takes abaout 20 seconds until I get the result. In a previous version of my code, instead of a datatable I used an ObservableCollection. In this case, to get the count, it only needs about 2 seconds. So what is the difference between datatable and ObservableCollection? How can I speed up this? What am I doing wrong?
I have been investigating into the issue you are seeing, but I am unable to reproduce a behavior where it takes a long time to evaluate a Count summary with around 1 million records as the times between the ObservableCollection and DataTable are similar on my end.
I am attaching the sample project I used to test this. Please test this project on your PC; whether or not it works correctly may help indicate the nature of this problem.
If the project does not work correctly, this indicates either a problem possibly specific to your environment, or a difference in the DLL versions we are using. My test was performed using version 21.1.20211.27 in Infragistics for WPF 2021 Volume 1.
If the project does show the product feature working correctly, this indicates a possible problem in the code of your application. It will help if you can provide a small, isolated sample application that demonstrates the behavior you are seeing.
Or, if this sample project is not an accurate demonstration of what you're trying to do, please feel free to modify it and send it back or send a small sample project of your own if you have one.
Please let me know if you have any other questions or concerns on this matter.
thank you for your response.
I tried it with your sample project and I also did not get any differences between ObservableCollection and Datatable in this case. I also tried, to reproduce my case with the code I used in my application, but I have not got it reproduced yet, so I have to investigate further.
But I therefore got another issue:
I checked the count box (the count was visible in the grid), then unchecked it (the count disappeared again at the bottom of the grid) and then checked it again and then the application got stuck. This happens all the time I do this.
I tried this with the following versions, and it always gets stuck:
My coworker is currently not available until next week, so I couldn't test the behaviour on his system yet, to see if this only happens on my system.
But then I'll check and give an update.
Thank you for your update on this matter.
I have reproduced the behavior where the reapplication of the Count summary is hanging the grid. This behavior is unexpected, and as such I have asked our engineering teams to examine it further. To ensure it receives attention, I have logged it in our internal tracking systems with a development ID of 273343.
I will be linking this to a private support case that I have created for you with an ID of CAS-214085-T4M6X1. You can access this support case after signing into your account on the Infragistics website, here: https://account.infragistics.com/support-cases.