Performance of Report con ReportCacheMode=Auto

Milton Guevara · Post by **Milton Guevara** » Tue Jan 20, 2009 10:46 am

Hello
I have a report 2000 pages from database IBM Informix, the report set "ReportCacheMode=Auto" by memory problems, but the report delay quite running (such as 20 minutes). Would like to know if there is any way to improve the speed of report (other tools run the same report in less than 10 minutes).
I'm using Version 2008.3 .315 with "Engine V1"
Change to "Engine V2" can improve performance?

Thank you
Milton

Post by **Edward** » Wed Jan 21, 2009 7:17 am

Hi Milton,

Yes, changing EngineVersion to EngineV2 can improve speed of rendering of the report, but it is unlikely that performance will be improved by two times.

Thank you.

Milton Guevara · Post by **Milton Guevara** » Wed Jan 21, 2009 9:41 pm

Hello Edward
Perform the change to "Engine V2", but the slow pace is maintained. I have verified that the 20 minutes that the report, half the time is delayed when displays the message "Finishing Report", what makes stimulsoft operations when this showing this message? ... is it possible to improve the performance in this part of the process?

Thank you
Milton

Post by **Edward** » Thu Jan 22, 2009 3:48 pm

Hi Milton,

10 minutes for generating of the report even in 2000 of pages is really too long. Maybe the report contains heavy images as its part?

When you see the 'Finishing Report' message, report starts processing of the information such as PageNumber or PageCount or any other information which is available only when the report is ready. As far as the report's pages have been stored in cache, engine retrieves them again and adds all necessary information into appropriate textboxes.

Please send to us first 3-5 pages of your rendered report (you can save it directly from the preview window) and mrt file as well.

Thank you.

Milton Guevara · Post by **Milton Guevara** » Fri Jan 23, 2009 10:35 pm

Hello Edward

Attached files.mdc and.mrt (980 pages)

I have seen other problems viewing the report:
1) The number of page is not displayed in it page 1
2) Some toolbar icons are not displayed, for example "Save", "open" (atached file jpg with the preview images)
3) Since it page 4 until the 934 are blank

Please help this is very urgent.

Thank you
Milton

Note:
The report has the following configuration
ReportCacheMode = Auto
LimitForStartUsingCache = 500

Milton Guevara · Post by **Milton Guevara** » Mon Jan 26, 2009 8:21 am

If necessary, also i have the cache files on disk.

Milton

Milton Guevara · Post by **Milton Guevara** » Wed Jan 28, 2009 8:35 am

Post by **Edward** » Mon Feb 02, 2009 11:27 am

Hi Miton,

Thank you for the files, but we need a sample project to reproduce the issue on our side. It seems that everything is ok with report template you sent to us.

Unfortunately there is no other way we would help to improve performance.

Thank you.