ReportProcessor.RenderReport XLSX format very slow when executes in Linux Container .NET 7 (Telerik.Reporting-18.0.24.130 2024-02-01)

0 Answers 64 Views
Converters General Discussions
Israel
Top achievements
Rank 1
Israel asked on 01 Feb 2024, 04:30 PM

We are experimeting a very slow perfomance when render report to xlsx format from version 17.2.23.1114 using .Net 7, render to pdf is perfect.
With Telerik 15.2.21.915 version report was fast using .net 5 

Test environment (.net 7 under linux container)
- api .net 7
- running in Linux Container. Pod Kubernetes
- nuget Telerik.Reporting (18.0.24.130)
- nuget Telerik.Reporting .OpenXmlRendering3 (18.0.24.130) with DocumentFormat.OpenXML 3.01 -DocumentFormat.OpenXml.Framework 3.0.1
- nuget Telerik.Reporting .WebServiceDataSource (18.0.24.130)
- nuget Telerik.Drawing.Skia (18.0.24.130)
- dockerfile includes next lines:
       RUN apt-get update
       RUN apt-get install -y libfreetype6
       RUN apt-get install -y libfontconfig1

We have this code to generate the report

 var reportSource = new InstanceReportSource { ReportDocument = _report };
 var reportProcessor = new ReportProcessor();
 var renderingResult = reportProcessor.RenderReport(format.ToString().ToUpper(), reportSource, null);
 var telerikReport = new DocumentResult(renderingResult);
 return telerikReport;

When we use format="XLSX" RenderReport is very low, when use PDF in the same report time is perfect.

In last versions of Telerik, 15.2.21.915, perfomance with XLSX was perfect the same API but in .net 5


What can we do?

 

Dimitar
Telerik team
commented on 05 Feb 2024, 08:58 AM

Hello Israel,

The difference between the new version and the 15.2.21.915 is that the one uses a new graphics engine for rendering reports on Linux - SkiaSharp.

We introduced the Skia engine with the Progress® Telerik® Reporting R3 2023 (17.2.23.1010) release and have been working on improving its performance since then.

With that being said, we are not aware of any slowness specific to the XLSX rendering extension wit the latest release. Do you experience slowness when you render the report to DOCX and PPTX too or is it only the Excel OpenXML format that is slow?

Could you please send a copy of your report and sample data to preview it so we can perform tests on it locally?

Kalli Kaldi
Top achievements
Rank 1
commented on 16 Apr 2024, 03:57 PM

We are experience the same problem with same version of telerik packages except we are using .Net8.  Same running environment, linux containers and Kubernetes.
Do you have any solution for this problem?
Ivan Ivanov
Telerik team
commented on 17 Apr 2024, 05:33 AM

We did some improvements in 18.0.24.305 that introduced font caching for Skia. In case that the reports that you are processing have a lot of text in them, you should experience significant performance boost with that version.
Israel
Top achievements
Rank 1
commented on 17 Apr 2024, 06:17 AM

Hi Kali, problem was solutioned with 18.0.24.305 version, now xlsx is faster !!! ;-)

No answers yet. Maybe you can help?

Tags
Converters General Discussions
Asked by
Israel
Top achievements
Rank 1
Share this question
or