1873281 - Poor performance when reporting off an Oracle Stored Procedure using the Crystal Reports Native Oracle driver (crdb_oracle.dll)

SAP Knowledge Base Article - Public

1873281 - Poor performance when reporting off an Oracle Stored Procedure using the Crystal Reports Native Oracle driver (crdb_oracle.dll)

Symptom

  • Report using the native connection (crdb_oracle.dll) to an Oracle Stored Procedure
  • The reports is 10-20 times slower than an ODBC connection to the same stored procedure

Environment

  • SAP Crystal Reports, developer version for Microsoft Visual Studio
  • Microsoft Visual Studio 2010

Reproducing the Issue

  1. Create a stored procedure in Oracle
  2. In Crystal Reports, create a Native connection (crdb_oracle.dll) to the Oracle stored procedure that has 10,000 or more records
  3. Refresh the report and take note of the time it took to refresh the report
  4. Using the Microsoft ODBC Administrator, create an ODBC connection to the Oracle server using the Oracle ODBC driver
  5. In Crystal Reports, set the data source of the report from the Oracle Native connection to the ODBC connection
  6. Refresh the report with the ODBC connection to Oracle, and take note of the time it took to refresh the report

Cause

  • The issue has been escalated for a fix
  • Reference: ADAPT01688843

Resolution

The issue is resolved in Service Pack 6 for SAP Crystal Reports, developer version for Microsoft Visual Studio

Keywords

KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Bug Filed

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio