PagesizeCData Excel Add-In for OData 2019 - Build 19.0.7354
The maximum number of results to return per page from OData when UseClientSidePaging is true.
The Pagesize property affects the maximum number of results to return per page from OData when when UseClientSidePaging is true. It will do nothing if when UseClientSidePaging is false. A higher value will return more results per page, but may also cause a timeout exception. If you must use client paging on your server and have a fast server, setting a higher Pagesize may be desireable. We recommend testing various sizes with UseClientSidePaging against a large resultset to determine what works best in your use case.