KB42629: When using Teradata as a warehouse in MicroStrategy 2021, a performance decrease is seen when a large number of rows are retrieved.

SYMPTOM:
Data transfer between Strategy and Teradata is slow. The performance degradation is typically seen in Teradata while publishing Intelligent Cubes or when a large number of rows are returned to Strategy from Teradata.
 
CAUSE:
The 'Max Response Buffer Size' parameter is not set for the Teradata ODBC connection.
 
ACTION:
The Teradata ODBC connection setting of 'Max Response Buffer Size' can be set in Strategy Desktop by following the below steps:

• Connect to your 3-tier Project Source in Strategy
• Open 'Administration' > 'Configuration Manager' > 'Database Instances':
  

• Edit an existing Teradata Database Instance and choose modify on the associated database connection:
  

• Navigate to the 'Advanced Tab' and input "MaxRespSize=1048576;" into the 'additional connection string parameters' field as shown below:
  

•  
  NOTE: 1048576 is the maximum value for this setting and also the recommended value.

As an alternative to the above steps, the 'Max Response Buffer Size setting can be applied directly on the Teradata ODBC Driver. If on Windows, the 'Max Response Buffer Size' is configured in the 'Teradata ODBC Driver Advanced Options' GUI as shown below:

 
If on UNIX/Linux the ODBC.ini entry for Teradata ODBC Driver can be modified to have the following parameters:
Sample Code/Error
MaxRespSize=1048576
 
 
More information concerning the additional connection string parameters feature can be found in the following Strategy Technical note:
 
KB42620 - How does the Additional Connection String Parameters feature for database connections work in MicroStrategy 9.x?