BulkPageSize
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 component 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 component parses the records in batches (or pages).
This connection property determines the maximum number of rows that the component loads into the result set per page.
Setting large page sizes may improve overall query execution time, but doing so causes the component to use more memory when executing querie.