Symptom
- Crystal Reports against Oracle database takes a long time to refresh
- Performance issue observed when running a Crystal Report against Oracle native connection
Environment
- Crystal reports 2008
- SAP Crystal Reports 2016
- Oracle database
Reproducing the Issue
- Create a new Crystal Report on Oracle Server connection
- Refresh the report, it will take a long time to refresh the report
Cause
Having “DoAutoSmartLinking” value set to 'Yes' causes Oracle to generate inefficient SQL to obtain metadata about an Oracle table, which in turn causes Crystal Reports to hang temporarily while waiting for a response from Oracle server. “Verify on First Refresh" option adds an extra call to the database to verify if the database metadata matches the report. It affects performance but not as much as SmartLinking.
Resolution
- Create a Crystal Report based on Oracle Server Connection
- Go to File menu -> Report Options
- Uncheck the option for “Verify on First Refresh” and “Automatic Smart Linking”
- Performance of the report will be improved significantly
See Also
1260284 - Slow performance when reporting from multiple data sources in Crystal Reports
Keywords
Crystal Reports performance issue with Oracle, Oracle 11gR2 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem