The following connection options can enhance driver performance.

Enable LOBs (EnableLOBs): The driver enforces native LOB data type mapping based on the value of this connection option. If set to 1 (Enabled), the driver enforces native LOB data type mapping. If set to 0 (Disabled), the driver provides backward compatibility for applications without LOB support that are using a version of Teradata Database prior to V2R5.1. This value can improve performance if your application does not send data to, or retrieve it from, LOB columns. You may receive an error if you disable this option and try to retrieve data from a LOB column.

Maximum Response Buffer Size (MaxRespSize): This option indicates the size of the Teradata response buffer used for SQL requests. The value may be adjusted dynamically if Teradata cannot send a result within the defined size. If using a slow TCP/IP interface, such as PPP or SLIP, enter a smaller value. If you expect to retrieve large result sets in a LAN environment, set a larger value to improve perfromance.

Enable Data Encryption (EnableDataEncryption): If enabled, the driver uses data encryption and communicates with the Teradata gateway using encryption. Data encryption may adversely affect performance because of the additional overhead (mainly CPU usage) required to encrypt and decrypt data. Using data encryption can degrade performance more than performing data integrity checks.