Creating reports and dashboards | Stimulsoft community forum

Hi Stimulsoft,
We're currently on Stimulsoft 2014.1.1900.0.
I've noticed when users attempt to preview reports in the Flash based StiMvcDesigner that datasets with moderate size (greater than 5000 records) cause the application pool's memory consumption to soar.
We don't have these types of issues in Winforms or other areas.

I was curious if there is a way to limit how many records are returned or maybe render portions of the report (first five pages for example) so the application pool doesn't run into an eventual OutOfMemory exception.

Currently I have worked around this by inserting a SELECT TOP 500 into the query, but if there is a setting like described above I would rather use it.

Thanks!

Hello,

Please check the last version and let us know about the result.
We made some improvements and optimizations in that direction.

Thank you.

Hello.

The browser and Flash player impose some restrictions on report size.
Also there is a limit of time that script can run.
Did you try to use Stop Before Page property of the report?
The rendering process will be stopped when specified number of pages will be rendered.

Thank you.

I will try the StopBeforePage approach.
Thank you!

Hello.

Let us know if you need our help.

Thank you.