Specifies the maximum number of records per page the provider returns when requesting data from CSV.

Data Type

int

Default Value

5000

Remarks

When processing a query, instead of requesting all of the queried data at once from CSV, the add-in can request the queried data in pieces called pages.

This connection property determines the maximum number of results that the add-in requests per page.

Note: Setting large page sizes may improve overall query execution time, but doing so causes the add-in to use more memory when executing queries and risks triggering a timeout.