Slow loading of data to SfDataGrid in wpf

[Eyal_Gilboa]

I have data with about 20 columns, which may contain even 20,000 rows. Right now in the tests I only have about 1000 records, and it takes the command to load about 15 seconds.. I understand that it shouldn't be like that..

After reading here

https://help.syncfusion.com/wpf/datagrid/data-virtualization

And here

https://support.syncfusion.com/kb/article/6938/how-to-improve-performance-when-loading-grid-with-records-and-columns-in-wpf-datagrid

I added "EnableDataVirtualization="True" but "UseDrawing="Default doesn't fit (and I didn't see that it helped either..) because it renders the Hebrew from left to right like a mirror script.. and I'm still not saved..

The same code loads the same data into a regular DataGrid control in a fraction of a second.

The xaml is attached (I removed some of the text or checkbox columns, when I left only 2 columns, it loaded after 3 seconds.. still a lot for only 2 columns..)

https://tchumim.com/post/161067

[Sweatha Bharathi]

Hi Eyal_Gilboa,

We analyzed your query and here we loaded the SfDataGrid with 250 columns and 2000 rows. The SfDataGrid took 3000 ms to load the data , it is loading fine as expected , we are not facing performance issue, and in comparison, the framework DataGrid took more time than the Syncfusion DataGrid. We have provided a sample for your reference. Could you provide additional details to proceed with your query?

1.Which version of Syncfusion are you using?

2.Have you made any customizations to the DataGrid?

3.The link you provided is not accessible for our team. If possible, could you provide a sample to replicate your scenario?

SfDataGrid Image Reference:

Attachment: SfDataGrid_Demo_b2e0c1ae.zip

[Eyal_Gilboa]

Indeed, the problem was with my custom scroll box controller, which affected it as well as the loading of the data.

Thanks

[Jayashree Suresh Anand]

Hi Eyal_Gilboa,

Thank you for sharing the details with us. We are closing this forum now. Please open a new forum thread if you need any further assistance.