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
Large number of records in preview
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
You can customize when the engine should start caching and how many quick access pages to store using these static properties
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
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