17.20 - Array Requests Limit - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

Array requests are limited to 1 MB. This impacts the number of parameter sets that can be applied to an array request. Assuming an SQL request text size of T bytes, a parameter row size of R bytes, and N parameter rows, the limiting conditions are listed in the following table:

Mode Limiting Conditions
Emulation mode N * R ≤ 64 KB and N * (T + R) ≤ 1 MB
Array support R ≤ 64 KB and T + N * R ≤ 1 MB

Each row is sent in a separate data parcel and is limited to 64 KB. The request text is not replicated. The whole request must fit within the 1 MB request limit. With DML Array Support, the number of rows that can be sent with a parameter array request is increased at least 16 times and up to 31 times for a large row of 33 KB.