2036608 - Crystal Reports 2008 performance issues when using Btrieve database

SAP Knowledge Base Article - Public

2036608 - Crystal Reports 2008 performance issues when using Btrieve database

Symptom

  • A report completes in seconds using the Crystal Reports 2008 designer or SAP Crystal Reports, Developer Version for Visual Studio .NET.
  • Running the same report in an application that uses the Crystal Reports 2008 SDK for Visual Studio .NET takes several minutes to complete.

Environment

  • Crystal Reports 2008.
  • Microsoft Visual Studio 2008.

Cause

  • The issue has been escalated for a fix.
  • Reference: ADAPT01727259.

Resolution

See Also

  • Additional suggestions to improve performance:
    • Find the clientSDKOptions.xml file in C:\Program Files\Business Objects\BusinessObjects Emterprise 12.0\win32_x86. Change “VerifyDatabaseOnSetDataSource” from “True” to “False”.
    • Add the Btrieve Key under HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\Database, then we add the string value “DoNotPadWithBlanksToFillCharColumns” and set it to “Yes”.
    • Add the String Value "AllAtOnce_BackwardCompatible" under HKEY_LOCAL_MACHINE\SOFTWARE\ Business Objects\Suite 12.0\Crystal Reports\Database\QueryEngine and set the value to 1.
    • Refer to KBA 2003458 - Crystal Reports .NET Runtime application slow to load with no internet access .

Keywords

crvs cr4vs slow ddf cr db , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem

Product

SAP Crystal Reports, developer version for Microsoft Visual Studio