ODBC Driver for Workday

Build 23.0.8839

ExpandMultiValueLimit

The maximum number of output rows that can be expanded from a single input row.

Data Type

int

Default Value

500

Remarks

When using ExpandMultiValues, the driver can generate multiple output rows for each input row from Workday. Each multi-value column included in the query increases the number of output rows exponentially. For example, if a table has five array columns and has one row has three values for each, then rows are generated in this pattern:

Number of Array Columns Selected Number of Output Rows
0 1
1 3
2 9
3 27
4 81
5 243

Realistic queries can output thousands of rows which can be expanded into hundreds of thousands of output rows. Generating these rows reduces the driver's performance and can potentially cause the driver to run out of memory.

To avoid this, the driver counts the number of output rows before actually generating them. If any input row would generate more rows than the ExpandMultiValueLimit, the driver reports an error instead. When this happens you should carefully evaluate the query and remove any array columns that are not required. Only increase this limit if there is no way to simplify your query.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839