SAP Knowledge Base Article - Public

1219691 - Crystal Reports XI .NET application loads data slowly

Symptom

In a .NET application, the ADO.NET driver loads data slowly. For example, setting a report to use an 18 MB XML file can take 15 minutes or more before the first page is returned.

Cause

This known issue has been assigned ID ADAPT00534409.

Resolution

Hot Fixes or Service Packs address this issue as indicated below. This issue occurs because the work of joining tables and removing records is being passed entirely to the query engine. With the update(s), filtering using ADO.NET is implemented so that the work is now completed before the result set is sent back to the query engine whenever possible. As a result, reports are generated more quickly.

Unless indicated otherwise, Critical Hot Fix updates from the FTP site have only been tested with English versions of our products.

====================

CAUTION:

Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM Product Warning.

====================

BusinessObjects Enterprise XI Release 2

-----------------------------------

For BusinessObjects Enterprise XI Release 2, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • crdb_adoplus.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_chs.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_cht.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_de.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_en.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_es.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_fr.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_it.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_jp.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_ko.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)
  • crdb_adoplus_res_nl.dll, version 11.5.1.377, dated 1/16/2006 (boXIr2win_chf.zip)

 

Crystal Reports XI for Windows

------------------------------------

For Crystal Reports XI, the latest update for this issue is available on the Downloads area of our web site.

This issue is addressed in the following components (and later versions):

  • crdb_adoplus.dll, version 11.0.0.1976, dated 12/30/2005 (commonXIwin.zip)
  • crdb_adoplus_res_en.dll, version 11.0.0.1976, dated 12/30/2005 (commonXIwin.zip)

 

Monthly Hot Fixes and Service Packs

------------------------------------------

To determine if this issue is also addressed in a Monthly Hot Fix or Service Pack for your product, search the readme file for the Track ID number (that is, ADAPTXXXXXXXX) in the latest Monthly Hot Fix or Service Pack.

Monthly Hot Fixes readmes and Service Pack readmes are available in the Downloads area of our web site.

====================

NOTE:

Issues addressed on one operating system platform at the Weekly Hot Fix level may be addressed later on multiple operating system platforms (if applicable) at the Monthly Hot Fix and Service Packs level. For example, an issue only resolved on the Windows platform in a Weekly Hot Fix may be resolved later on UNIX platforms such as IBM AIX and Sun Solaris in future Monthly Hot Fixes or Service Packs for these platforms.

To determine if these issues are resolved in a Monthly Hot Fix or Service Pack on another platform, search for the Track ID number in the readme at the locations indicated above.

See Also

For more information on the issues addressed in the Hot Fix or Service Pack, view the readme PDF or text file included in the ZIP or TAR file.

For more information on the different update types, refer to our Hot Fix and Service Pack FAQ.

Keywords

CHF 534409 SLUGGISH POOR PERFORMANCE SLOW TAKES LONG TIME TOO LOADING Crystal Reports .NET Application ADO.NET Slow Performance , c2018729 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2