SAP Knowledge Base Article - Public

1680608 - Crystal Reports against Oracle database takes a long time to refresh

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 SP4
  • Oracle 11g R2

Reproducing the Issue

  1. Create a new Crystal Report on Oracle Server connection
  2. 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

  1. Create a Crystal Report based on Oracle Server Connection
  2. Go to File menu -> Report Options
  3. Uncheck the option for “Verify on First Refresh” and “Automatic Smart Linking”
  4. 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 BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1