SAP Knowledge Base Article - Public

1200864 - Slow performance when using Crystal Reports XI against Oracle 10G on UNIX

Symptom

Running a simple report in Crystal Reports XI connecting to an Oracle 10G database on a UNIX server takes a long time to process.

Cause

The report is using an Oracle ODBC driver for the Oracle 9i client. This driver is causing the slow performance.

Resolution

Download and use the correct DataDirect ODBC Drivers for your version from the following site:
http://www.businessobjects.com/products/downloadcenter/crystalreportsxi.asp 
 

Keywords

Slow performance, Slow, ODBC, Oracle, Oracle 10G, Performance hit , 5043385 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2