The Response Buffer Size governs how many rows are returned from the Advanced SQL Engine back to a client in one Response. For example, approximately 81 rows will fit into one Response when the row size is 100 bytes and the Response Buffer Size is set to 8192 bytes. In this example, a larger Response Buffer Size might improve performance as the number of roundtrips between the Client and the SQL Engine is reduced. You should consider the network physical characteristics and application resource utilization when fine tuning the Response Buffer Size. For example, you might consider tuning for application resource utilization (memory) when network latency is low and application is executing high number of tactical queries.

Teradata Advanced SQL Engine version 16.10 supports a maximum of 16,775,168 bytes in the Response Buffer. Response Buffer Size is a connection level property and applies to all commands executed against the connection. Therefore every command will allocate the specified Response-Buffer-Size bytes of memory. In application server scenario there are multiple connections and multiple commands executing simultaneously within the same process. Therefore the overall process memory utilization is affected by the Response Buffer Size.

The .NET Data Provider for Teradata normally uses double buffering in order to improve performance. This does, however, mean that it will use twice as much memory as you might expect for its response buffers.