1873343 - Poor report performance in Visual Studio application when connecting to a Btrieve database

SAP Knowledge Base Article - Public

1873343 - Poor report performance in Visual Studio application when connecting to a Btrieve database

Symptom

  • Report connecting to a Btrieve database finishes in time X
  • The same report running in a Visual Studio .NET application will take four to 5 times longer to finish

Environment

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

Reproducing the Issue

  1. Create a report connecting to a Btrieve database
  2. Run the report in the Crystal Reports Designer - note the performance
  3. Run the same report in a Visual Studio .NET application - note that performance is much worse

Cause

  • The issue has been escalated for a fix
  • Reference ADAPT01681032

Resolution

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

See Also

  • Additional suggestions to improve performance:
    • Find the clientSDKOptions.xml file in C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86. Change “VerifyDatabaseOnSetDataSource” from “True” to “False”.
    • Add the Btrieve Key under HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.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\SAP BusinessObjects\Crystal Reports for .NET Framework 4.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 2012 slow speed net , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports, developer version for Microsoft Visual Studio