Performance issue for painting the spreadsheet component

[Omar]

Hello,

So, I've been trying to identify the root cause of why loading the Spreadsheet component taking too much time (about 20 secs)
 After running many performance recording on multiple browsers, I found that on chrome and edge it take about 14 sec to render and paint the spreadsheet.
and it gave me a warning in the recording says 'too long task' as attached.

Not surprisingly, on Firefox it took about 4 secs which is much faster.

Also, I tried to the same thing on the demo page of the Spreadsheet component and found the same performance issue with the same warning message
https://ej2.syncfusion.com/vue/demos/#/material/spreadsheet/default.html

Thanks

Attachment: Screenshot_20210325_145713_c70f9ab8.rar

[Sangeetha Priya Murugan]

Hi Omar, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported issue based on your provided screenshot and we would like to let you know that, in our demo site we have included all our syncfusion control packages. So, it takes some time to load the site. So, we would suggest you use spreadsheet package alone in your application to avoid this issue in your end. For more details, please refer the below documentation link. 

 

https://ej2.syncfusion.com/vue/documentation/spreadsheet/getting-started/  

 

If you still getting the same issue, please get back to us with the customization codes, syncfusion version, and data loaded in the spreadsheet (JSON data or imported excel file). Based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M 

[Omar]

Hello Sangeetha,

I'm not using any customization codes, I'm just using the vue-component as it is from npm.
Regarding the version, it is: "@syncfusion/ej2-vue-spreadsheet": "^18.4.48"

And the document I'm trying to open is a blank excel document, I attached it for your reference.

Thanks a lot for your help

Attachment: BlankExcel_a396b0f4.rar

[Sangeetha Priya Murugan]

Hi Omar, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your provided excel file and the file imported properly in our end without any delay. For your convenience, we have prepared the video demonstration of this. Please find the link below. 

 

Video Link: https://www.syncfusion.com/downloads/support/forum/163878/ze/import-issue603388773  

 

And we suspect that you have referred the older version for spreadsheet packages in your end. So, we suggest you to use our latest version (18.4.48) for both scripts and assemblies to resolve this issue in your end.  

 

Could you please check this issue in the latest version and kindly get back to us, if you still getting the same issue or need further assistance on this. 

 

Regards, 

Sangeetha M 

[Omar]

Hi Sangeetha,

Actually it works fine when trying to open the excel file, because the spreadsheet component itself is loaded already.
The issue is related to painting the spreadsheet component itself for the first time (which is taking too long) not opening the document itself.

You can check with refreshing the page and recording performance to see how much time it takes to paint the component in both Chrome and Firefox.

Thanks,

[Sangeetha Priya Murugan]

Hi Omar, 

 

Thank you for your update. 

 

We have checked your reported issue and the spreadsheet rendered without any delay even importing your provided excel file in the created event. For your convenience, we have prepared the sample based on your requirement. Please find the links below. 

 

Sample Link: https://codesandbox.io/s/recursing-resonance-2c047  

 

Service Link: https://www.syncfusion.com/downloads/support/forum/163878/ze/ASPNET~11535337567  

 

Note: launch the service first and then open the codesandbox sample for import and export. 

 

Could you please check the above details and replicate your issue in the above sample and send back to us? Based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M 

[Omar]

Hi Sangeetha,

Again, the issue is not related to opening the document itself, the issue is related to painting and rendering the spreadsheet component.
Please, try to load a page that contain an empty spreadsheet component both in Chrome and Firefox and compare the speed of page load.

Also, please do performance recording to see how much time it takes to paint the component.

Thanks,

[Sangeetha Priya Murugan]

Hi Omar, 

 

Thank you for your update. 

 

We have checked your reported issue and the spreadsheet rendered properly without any delay. So, please share us the local issue replicable sample and video. Based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M 

[Omar]

Hi Sangeetha,

Kindly find the recording attached. It took about 20 secs to paint the component even though it's just an empty excel document.
I already checked the network and it took less than 2 secs to fetch the file and rest of the time is just for painting the component.
Kindly notice the difference in performance between Chrome and Firefox.

Thanks a lot

Attachment: spreadsheetBrowserComparison_6da69218.rar

[Sangeetha Priya Murugan]

Hi Omar, 

 

Thank you for your update. 

 

We have checked your reported performance issue based on your provided video. In this you have rendered the spreadsheet in the dialog box. For your convenience, we have prepared the sample that load the excel file from the server in spreadsheet inside the dialog box. And spreadsheet rendered less than 10 seconds in chrome browser. For your convenience, we have prepared the video demonstration of this. Please find the link below. 

 

Video Link: https://www.syncfusion.com/downloads/support/forum/163878/ze/performance-issue957229518  

 

Local Sample Link: https://www.syncfusion.com/downloads/support/forum/163878/ze/quickstart1995770155  

 

Could you please check the above details and replicate your issue in the above sample and send back to us? Based on that we will check and provide you a better solution quickly. 

 

Regards, 

Sangeetha M