After I restart my machine, When I open a crystal report using my .NET application, the very first time it takes around 30 to 40 seconds, after that it takes from 3 to 10seconds.
We want to improve the performance. I have tried lot of things that I found on this forum on the below threads
Crystal2008 problem with Record Select Expert, only in .NET not in Designer
Loss of Performance when Upgrading Project to CR2008
After adding the timers like you(Ludek) mentioned in the first thread, It is confirmed that the performance hit is actual report load "_reportDocument.Load(report.rpt)"
1. Unchecked the "Check for publisher's certificate revocation"
2. Added new registry entries for "DisableCheckForUpdates 0", "DisableOnStartUp 0", "VerifyWhendriverUpdate No" under "Business Objects\Suite 12.0\Crystal Reports"
3. Unchecked Report options "Verify On First Refresh" and "Verify Stored Procedures on First Refresh"
4. Tried the "No Printer" option
5. Deleted the subreport
6. Used "Page 1" instead of "Page 1 of totalpages"
7. Tried add the following in app.exe.config file
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<runtime>
<generatePublisherEvidence enabled="false"/>
</runtime>
</configuration
Nothing seemed to effect my initial delay. This is happening on both developemnt and the test machines.
My application is in visual studio 2008. crystal reports 2008 with sp0. I use OLE DB(ADO) connection to connect to my Sybase 8 database. I know there is a latest service pack. But I see lot of complaints with the new service pack also i saw in people's comments that upgrading service pack didn't affect their delay. We are so close to release that I can't take risk with this new service pack.
Is there any thing else that I can try to improve my initial delay?
It is really critical to me. Please help.