CData Excel Add-In for OData 2019 - Online Help
Questions / Feedback?

Pagesize

CData 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.

Data Type

string

Default Value

"1000"

Remarks

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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0