Aspose.Words for RS 4.1.0 Performance issue (slow TimeRendering)

sviatoslav_starovoit · April 18, 2014, 10:01am

Hi Aspose,

I noticed that my reports have performance problems after migration to aspose.words for RS version 4.1.0. Before migration I used 2005 rdls with Aspose.words for RS version 3.3.1.

I attached report.

My steps:

I have a simple rdl with only one TextBox.

I generate a report three times than connect to RS database and run query: “SELECT * FROM [dbo].[ExecutionLogStorage]”

TimeRendering result:

1545 ms
1037 ms
1136 ms

With old version of Aspose, TimeRendering was about 1- 10 ms.

I used AWDoc format.

Please take a look. What could cause this? Is it possible to raise the performance?

Thanks in advance!

Sviat

tahir.manzoor · April 21, 2014, 1:27am

Hi Sviatoslav,

Thanks for your inquiry. I have tested the scenario while using latest version of Aspose.Words for Reporting Services 4.1.1 with ‘SQL Server Business Intelligence Development Studio’ and have exported the RDL to Doc/Docx less then a second.

Are you checking this performance issue while exporting the RDL (e.g Doc/Docx etc) or Rendering of RDL?
It would be great if you please share the steps to reproduce this issue at our end. We will then provide you more information about your query.

sviatoslav_starovoit · April 22, 2014, 6:00am

Hi Tahir,

Please see STR:

RS 2012

Go to RS 2012 ReportManger (http://localhost/Reports/Pages/Folder.aspx)
Click “Upload file” and upload attached RDL file. (PerformanceIsuue2012.rdl)
Open PerformanceIsuue2012.rdl file.
Click export to “DOC - Word Document via Aspose.Words”
Go to SQL Server Mangment Studio and connect to “ReportServer” database for RS 2012.
Run Query - “SELECT TOP 5 * FROM [dbo].[ExecutionLogStorage] ORDER BY TimeStart DESC”

RESULT: Please take a look on “TimeRendering” column:

1020 ms
1028 ms
1028 ms

RS 2005

Go to RS 2005 ReportManger (http://localhost/Reports/Pages/Folder.aspx)
Click “Upload file” and upload attached RDL file. (PerformanceIsuue2005.rdl)
Open PerformanceIsuue2005.rdl file.
Click export to “DOC - Word Document via Aspose.Words”
Go to SQL Server Mangment Studio and connect to “ReportServer” database for RS 2005.
Run Query - “SELECT TOP 5 * FROM [dbo].[ExecutionLog] ORDER BY TimeStart DESC”

RESULT: Please take a look on “TimeRendering” column:

2 ms
2 ms
2 ms

I attached Excel document with results.

Thanks,

tahir.manzoor · April 23, 2014, 3:19am

Hi Sviatoslav,

Thanks for sharing the detail. I will setup the SQL Server Reporting Services 2005 at my side to test the shared scenario. As soon as everything is setup, I will test the issue at my end and will post the results here for your kind reference.

Thank you for your patience and understanding.

sviatoslav_starovoit · April 24, 2014, 8:29am

Any updates?

tahir.manzoor · April 24, 2014, 11:17am

Hi Sviatoslav,

Thanks for your patience.

I
have tested the scenario and have managed to reproduce the same issue
at my side. For the sake of correction, I have logged this problem in
our issue tracking system as WORDSRPT-172. I have linked this forum thread to the same issue and you will be notified via this forum thread once this issue is resolved. We apologize for your inconvenience.

Could you please test the same scenario with some large RDL files and share your finding here for our reference? Please let us know if you face the same performance issue with small and large RDL files.

sviatoslav_starovoit · April 29, 2014, 7:07am

Thanks Tahir.

Yes, I face the same performance issue with small and large RDL files.

tahir.manzoor · April 29, 2014, 1:34pm

Hi Sviatoslav,

Thanks for sharing the detail.

It would be great if you please share RDL file which contains large contents here for our reference. We will investigate the same issue with large RDL on my side and provide you more information.

sviatoslav_starovoit · May 7, 2014, 4:04am

Tahir,

I don’t have sample RDL file which contains large contents, I have only project RDL files which i cannot share. But you can be sure that I checked the performance of them and faced the same issue.

Sorry for delay.

Sviat

tahir.manzoor · May 8, 2014, 3:38am

Hi Sviatoslav,

Thanks for your feedback. We will update you via this forum thread once this issue is resolved. Please let us know if you have any more queries.

sviatoslav_starovoit · May 27, 2014, 4:58am

Hi Tahir,

Please test the same issue for DOCX renderer.

STR:

Go to RS 2012 ReportManger (http://localhost/Reports/Pages/Folder.aspx)
Click “Upload file” and upload attached RDL file. (PerformanceIsuue2012.rdl)
Open PerformanceIsuue2012.rdl file.
Click export to “DOCX - Office Open XML via Aspose.Words”
Go to SQL Server Mangment Studio and connect to “ReportServer” database for RS 2012.
Run Query - “SELECT TOP 5 * FROM [dbo].[ExecutionLogStorage] ORDER BY TimeStart DESC”

RESULT: Please take a look on “TimeRendering” column:

1033 ms
1029 ms
1027 ms

Thanks,

Sviatoslav

tahir.manzoor · May 28, 2014, 3:06am

Hi Sviatoslav,

Thanks for your inquiry.

I
have exported the shared RDL to Docx using v 3.3.1 and v 4.1.0 and have managed to reproduce the same issue
at my side. I have logged this detail in our issue tracking system. We will update you via this forum thread once this issue is resolved. We apologize for your inconvenience.

sviatoslav_starovoit · February 16, 2016, 4:50am

Hi Aspose Team,

Are you still looking into this issue?

Thanks,

Sviatoslav

tahir.manzoor · February 17, 2016, 2:48am

Hi Sviatoslav,

Thanks for your inquiry. We are in communication with our product team about the status of this issue. As soon as any information is shared by them, we will be more than happy to share that with you.

Thank you for your patience and understanding.