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 add-in 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 add-in parses the records in batches (or pages).

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

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