Grid performance issues with dynamic binding of columns

[Matt Broich]

Hello,

I am currently generating columns from a Stored Procedure in a grid. The current load time is approximately 15-20 seconds depending on the page size (I am using paging). The Stored Procedure executes in under a second, and the binding of data doesn't seem to be an issue to performance either. Is there any underlying source code that may cause performance issues with dynamic binding?

Note: The total number of columns can be up to 120.

Any feedback would be appreciated, thank you!

EDIT:

We found the culprit, "AllowResizeToFit" is extremely detrimental to the performance of the grid. 

[Sathyanarayanamoorthy Eswararao]

Hi Matt, 

Thanks for contacting Syncfusion support. 

Query : "AllowResizeToFit" is extremely detrimental to the performance of the grid.  

 

When AllowResizeToFit is enabled with large number of rows and columns (for example: 120 columns and 10 rows) then 1200 cells need to be processed to set the width for the columns based on the content of the cells. So the rendering process will take time with allowResizeToFit and large number of rows and columns, which is the default behavior of the Grid. 

If you have any other queries, please get back to us we will be happy to assist you. 

Regards, 

Sathyanarayanamoorthy