SfDataGrid Performance

[svrz]

Greetings

In numerous projects, load times of 2-5 seconds are seen with SfDataGrid. Attached to this message is a small project that is representative of a requirement. When the toolbar item is pressed, a page with SfDataGrid as the only control is loaded. The XAML and the ViewModel code are taken directly from the SfDataGrid samples.  A fair sized amount of data is loaded on to this grid but I have seen similar load times with only a few rows of data.

Any hints or help in regards to performance improvement is greatly appreciated.

Thanks in advance.

Attachment: SfGridMainPageTest_399aae85.zip

[Shivagurunathan Kamalakannan]

Hi svrz, 

 

Thanks for contacting syncfusion support. 

 

We have checked your query and have tested the loading time of the DataGrid control with different set of inputs. We observed the below loading time when loading the SfDataGrid initially and when populating the grid in runtime. However, we will still continue to check on this to reduce the loading time further if possible.  

 

The initial loading time of the grid here is recorded including the time taken for the page to load in Xamarin.Forms which is around 600 milliseconds to 1.5 seconds by default.  

 

Refer the below table for the observed time: 

 

View loaded	Grid loading time along with the page loading (in milliseconds)	Loading time of Grid only(in milliseconds)
Label	572
Grid with 100 rows	250-500	<50
Grid with 1000 rows	460-600	<100
Grid with 10000 rows	750-870	180-230

 

Regarding your query, “Any hints or help in regards to performance improvement” 

 

The properties EnableDataVirtualization and NotificationSubscriptionMode allows you to give the better performance in terms of loading and scrolling. 

 

1. set EnableDataVirtualization to true.
1. This will allow you virtualize the data items generated to bind to the grid there by creating only the required data objects to be loaded in view rather creating the total number of records that is populated.
2. set NotificationSubscriptionMode as none.
1. This property will allow you to customize the notification subscription in SfDataGrid. If you do not want to subscribe to any notifications in your sample you can set this to None. You can also customize this to property change and collection change alone.

 

Refer the below link sample for reference. 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/SfGridMain1609676918 

 

 

Regards, 

Shivagurunathan. K 

 

[svrz]

Hello Shivagurunathan

Thank you for the prompt reply. Conversely I apologize for a tardy one. :)

I will incorporate your suggestion into my project. Your sample project nicely demonstrates the adequate loading times.

Again, thank you very much for the thorough explanation and the sample project.

Take care

[Shivagurunathan Kamalakannan]

Hi svrz,  

Thanks for contacting Syncfusion Support.  

Please let us know if you require any further assistance. 

  

Regards, 

Shivagurunathan. K