Crystal Reports Running Very Slow
I am not sure if it is by adding alot of tables into the report database or is it because of the formula or anything else but two of my reports are running really slow these days.
Both of the reports hold 7 tables altogether with 5 parameters of which 2 are dynamic. When I press F5 on my report sometimes it takes 1mins to load and some times good 5mins. Similarly while processing it takes from 6mins to good 15mins.
(Like now I ran the report for June month since 15:39 it is still running and now its 15:58 and it has finally loaded)
I simply do not understand why would the report take so long to load.. Once it load quicker and I checked the performance under Report performance and it stated 626ms Generate page, 2ms for formatting page.
On my recent attempt it states
Run the database query - 87238ms
Read database records - 30691ms
Format First Page - 981428ms
Average time to format page - 327143ms
Average time to generate a page - 58980ms
Time to format all charts (there is only 1) - 332014ms
I have similar reports with 6 tables and 4 parameters however they take flick of an eye and produces the results.
Is it to do with indexing on the database server? or my report coding has issues or something else?
I am using Crystal Reports 2008, ODBC connection to Informix Database 7.3.
Please advise on this