Page 1 of 1
Large Amounts of Data
Posted: Thu Oct 01, 2009 12:16 pm
by marcuslienhard@hotmail.com
Is there any success in dealing with data the starts at about 1 million rows and can grow to over 25 million? Everytime i run a report, it runs out of memory. Any ideas on how it could still work?
Large Amounts of Data
Posted: Fri Oct 02, 2009 2:43 am
by Edward
Hi,
Huge amount of pages in a web reports can lead to the lack of server memory. More than 300 pages is a very big report for Web. It could take around 300...500Mb of the ASP.NET server memory and even more if there are images in the report pages. The server itself does not provide such amount of memory for the process can be interrupted. There is only one decision. It is to split big report into some smaller ones.
You can use dialogue forms in report in web, queries with parameters, so every possible solution for limitation of the amount of pages in the report.
Here is the list of requirements for reports with dialogue forms:
1) StiWebViewer.RederMode must be AjaxWithCache or UseCache.
2) Code of rendering report must be in any other place but not in PageLoad event of the WebPage. You can place this code for example inside the ButtonClick event.
3) Dialogues will work in web only when StartMode property in Dialogue Form is set in 'OnStart'
If these three requirements are satisfied, then your report will work with dialogues in Web environment.
Thank you.