This is a migrated thread and some comments may be shown as answers.

Handle and display heavy data in spreadsheet

3 Answers 320 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
LW
Top achievements
Rank 1
LW asked on 22 Jan 2021, 06:40 AM

Hi,

 

We had been using kendo spreadsheet with heavy load of data around 200+ columns and 500+ rows on one sheet. Each cell width and height is around 10 - 15px respectively which we want user to overview their data. Hence, displaying and rendering a lot of cells of data which will cause overloading of memory and performance. The problem is we also keep fetching and rendering the data from server after some modification. This causing the website will drop framerate and causing the website "not responding" for few seconds.

Is there any solution to render the spreadsheet "smoother"? And we are thinking of solution to render the spreadsheet at the background but not sure how. OR is there other solution or component to load this heavy load of data? Any solution is welcome.

 

Thanks,

Fungus.

 

3 Answers, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 25 Jan 2021, 05:44 PM

Hello,

In some scenarios loading large data in the Spreadsheet could lead to performance issues. However, I have tested to load 20 columns and 4500 rows in Spreadsheet (90000 cells), and the data was loaded on my end without any issue. Could you please let me know if the issue occurs in all browsers or in a specific one? Could you please share the Spreadsheet configuration so we could perform tests with scenario closer to yours?

Looking forward to your reply.

Regards,
Neli
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
LW
Top achievements
Rank 1
answered on 27 Jan 2021, 01:32 AM

Thanks for input.

The problem was due performance issue of loading large data and rendering numerous cell of kendo spreadsheet at once. The requirement needs that without kendo spreadsheet scrolling the page render the whole data (10000+ cells). In this circumstance, the issue mentioned will occur without doubt. It's not the issue for kendo spreadsheet but in our perspective using kendo spreadsheet rendering large data is the best for our requirement. Hence, we are seeking better solution to solve the heavy data rendering problem or render kendo spreadsheet in different way.

If I post in the wrong platform, please let me know. Thanks

Regards,

Fungus.

0
Neli
Telerik team
answered on 28 Jan 2021, 02:15 PM

Hi LW,

Could you please share more details about the implementation at your end? In order to be able to provide suggestions for resolving the issue, we will need more information about the performed operations related to the Spreadsheet and the modifications you mentioned. Also, more information about the widget configuration could be helpful.

For example, performance issues could be observed when the range method is called for a big number of cells. In such a case, after each call of the range method, the Spreadsheet is re-rendered and this could lead to performance issues. For such scenarios, we suggest using the batch method. Of course, this is just an example, and to provide a suitable suggestion we will need more details about the issue. 

Regards,
Neli
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Spreadsheet
Asked by
LW
Top achievements
Rank 1
Answers by
Neli
Telerik team
LW
Top achievements
Rank 1
Share this question
or