Creating reports and dashboards | Stimulsoft community forum

Hello!

We have a huge problem with memory consumption, during the report rendering more than 2.2 GB of RAM is allocated, and the Excel2007 export costs additional 1.4 GB. Our application server - where reports are rendered - literally runs out of memory and crashes. We need to reduce the memory consumption somehow. The report template reads data from an Oracle database and the number of displayed rows in the report is over 200000. We tried CSV export, which resulted in 500 MB additional memory usage during the report export. How can we force the reporting engine to use less memory?
Our target is to push the memory consumption for the report rendering + export below 500 MB.
Thank you for the answer.

Jozef

Hello,

On current moment we working on optimization of exports. Try to made some improvements within one or two months.

Thank you.

I understand, but we would welcome optimization of the render process too. I assume the rendering contains information about cell formats, which is not useful for us, when the export is done to CSV or Excel without data formatting. Is it possible to disable formatting in the report rendering?
Could you please look at the attached report template? It contains a simple data band with 15 columns. I would like to as You to suggest which parts of the template should be modified and how to reduce memory usage for CSV or Excel export. Thank you for your time.

Jozef

Hello,

Please try to set the ReportCacheMode property to On value.
Also please try to use the following option:
StiOptions.Export.UseCacheModeForStiMatrix = true;
Available in the last prerelease builds.

Thank you.