Specifies the maximum number of records per page that the provider requests when retrieving data from Amazon Marketplace.

Data Type

string

Default Value

""

Remarks

When processing a query, the provider retrieves results in batches called pages instead of requesting all of the queried data at once. This property sets the maximum number of records the provider requests in each page.

Amazon Marketplace enforces a different maximum page size for each table, so the value you set here is capped on a per-table basis. If the value exceeds a table's maximum, the provider automatically lowers it to that table's maximum. For example, the CatalogItems and Listings tables allow at most 20 records per page, while ReportList, Feeds, and FinancialEventGroups allow up to 100. Because there is no single global maximum, the effective page size can differ from table to table even when this property is left at one value.

If you leave this property empty, the provider lets each table use its own default page size. A LIMIT clause in your query takes precedence over this property.

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