Page 1 of 1

Large number of records in preview

Posted: Fri Jun 05, 2009 11:23 am
by Arthur
I am having issues previewing a large number of records. The records are pulled pretty quickly from the DB and I can see the rows in the dataset, but when I try to preview the report, my computer comes to a halt. Is there any way to cache the data or have it render only a page or two at a time in the preview?

Do you have any other suggestions to improve the response time?

-Arthur


Large number of records in preview

Posted: Fri Jun 05, 2009 11:44 am
by Brendan
Hi Arthur,

You can try caching some of the pages to disk instead of in memory to see if it will improve performance.

You need to turn on the Report Cache property

Image

You can customize when the engine should start caching and how many quick access pages to store using these static properties

Code: Select all

StiOptions.Engine.ReportCache.LimitForStartUsingCache
StiOptions.Engine.ReportCache.AmountOfQuickAccessPages