Why reports created in 8.5 and saved in XI.5 are very slow?
Here is my problem :
I worked with Crystal Report 8.5 and my reports were speedy.
I saved a report in a new version (Crystal XI.5) and the report generation is very slow.
If i saved the same report (saved in 8.5) in the version XI (not the XI.5) the report is speedy.
If i saved the report from XI.5 to XI there is no change (report slow).
Have you ever seen this problem?
The database used is Advantage Database Server 220.127.116.11
Thanks for the help.
It is expected that the reports will run a bit slow in the newer version as the entire report engine has undergone chnage after version 8.5.
With the new version, the database security has been enforced a lot more as compared to version 8.5. Along with this, the SQL generation process has also undergone change and the SQL which is now generated is much more optimized.
Also, there are a lot of new features in terms of formatting the report, which can cause the delay in showing you the first page of the report. It may not just be the database access that is taking time.
As suggested earlier, if you find the query generated in 8.5 was fetching records faster, you can surely create a command object in XI R2 to check if you get the same speed of data retrival.