Slow Report Rendering & Memory Limits

[tastelessrowboat]

I am encountering significant performance and stability issues when rendering complex reports using the Stimulsoft Reports.PHP component, and I'm hoping to get advice on best practices for optimization in a high-traffic environment. Reports take an unacceptable amount of time to generate before the viewer even loads. This occurs even when the underlying SQL query executes in under 2 seconds. For larger reports, the PHP process frequently hits the `memory_limit` and fails with an out-of-memory error. Once loaded, the HTML viewer is sluggish when navigating between pages or exporting to PDF/Excel.

[Lech Kulikowski]

Hello,

Please see articles about report optimization:
https://www.stimulsoft.com/en/blog/arti ... ng-reports
https://www.stimulsoft.com/en/blog/arti ... rts-part-2
https://www.stimulsoft.com/en/blog/arti ... rts-part-3

Thank you.