Specifies the maximum number of records to process per page when reading asynchronous job results.

Data Type

int

Default Value

5000

Remarks

Note: This property only applies to objects in the Model schemas.

When the connector initiates an asynchronous operation (such as an export action, which is represented as a table in the model schemas), instead of loading all of the exported data into memory at once, the connector parses the records in batches (or pages).

This connection property determines the maximum number of rows that the connector loads into the result set per page.

Setting large page sizes may improve overall query execution time, but doing so causes the connector to use more memory when executing querie.