Aspose Cells for SSRS export taking a long time

Aspose.Cells Product Family
1

We have a report that is rendered from a snapshot. Rendering from the snapshot takes seconds. Rendering from the db takes 3 minutes. Rendering to Excel 2007 via Aspose.Cells takes 14 minutes.

The report is 100K rows.

Is there a way to make this export faster? It’s pretty much useless the way it is. Users will not wait this long.

2

Hi,


Thanks for providing us some details.

Could you try to set Performance configurations, see the document for your reference:

Thank you.

3

That page doesn’t really do a very good job of describing what the value of each parameter should be to extract the best performance.





In fact, after taking an even closer look, the documentation doesn’t even indicate what each parameter even does. How is this supposed to help?



Can you give some hints?

4

Hi,

Thanks for using Aspose.Cells for Reporting Services.

Please post your report define file here. We will check it asap and update you.

5

Here you go.

6

Hi,

Thanks for your RDL file and using Aspose.Cells for Reporting Services.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, there is some fix or other update for you, we will share it with you asap.

This issue has been logged as

  • SSRS-40214 - Aspose Cells for SSRS export taking a long time

7

Is there any update to this? This is a show stopper for us and preventing us from moving to Production.

8

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services.

We are afraid, there is no update for you at this moment. However, we have logged your comment in our database against this issue and requested the product team to provide some fix or ETA for this issue. Once, there is some news for you, we will let you know asap.

9

Hi,

We have fixed the method for TextBox’s shrink and grow.

It makes export faster when you update performance settings in Aspose.Cells.ReporingServices.xml file.

==============================================================================

………………

False" IsMerged=“True” IsSetStyle=“True” IsConditionalFormatting =“False” LimitCellsNumberForMerged="-1" >

False"/>

…………….

==============================================================================

Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008R2) V2.2.0.7 (attached).

Please copy Aspose.Cells.ReportingServices.dll into following folder : ${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know your run result.

Thank you.

10

This helped a small amount, but we still face extraordinarily long export times for files that are only 100MB or so.


When creating the export, does the Aspose code have to query the database again or does it use the cached snapshot? All of our larger reports are cached in report snapshots.

I wrote a quick program that selects 200,000 records from a table that has 440 columns and writes the output to a CSV file. Once the query ran, the time it took to create the CSV file was 1.5 minutes. The resultant file was 900 MB.

We also need to report another bug. When exporting to CSV, if a value in the data is blank, no “comma” is included for this value, so the column names will not align with the data.
11

Hi,

Thanks for your feedback and using Aspose.Cells for Reporting Services.

We have logged your comment in our database against this issue for investigation. We will look into it and update you asap.

For your newer issue, please feel free to create another separate thread. It will help us look into your issue and fix it in better way.

12

Hi,

Thanks for using Aspose.Cells for Reporting Services.

We have optimized algorithm for Aspose.Cells for Reporting Services.

Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008) V2.2.0.11.

Please copy Aspose.Cells.ReportingServices.dll into following folder:

${SQL Server 2008 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know your run results.

About CSV rendering, we do not directly create CSV file.

We create excel file, then convert excel file to CSV file.

13

The issues you have found earlier (filed as SSRS-40214) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.