---
schema_version: "1"
id: 46fe668dc5b90186a5923f6fe4584557f85d363039a2f32293156d02f16997d7
title: Client-Driven and Server-Driven Paging for Salesforce Connect OData Adapters
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/odata_paging.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.odata_paging.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f4fdc52368491ae78d8a05d25faef4c7d5f78a38d3e54f5dc966707fa8a1b482
description: It's common for Salesforce Connect queries of external data to have a large result set that's broken into smaller batches or pages. You can decide whether to have the paging behavior controlled by the external system (server-driven) or by the OData adapter for Salesforce Connect (client-driven).
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Client-Driven and Server-Driven Paging for Salesforce Connect OData Adapters

It's common for Salesforce Connect queries of external data to have a large result set that's broken into smaller batches or pages. You can decide whether to have the paging behavior controlled by the external system (server-driven) or by the OData adapter for Salesforce Connect (client-driven).

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
      <colgroup>
        <col>
      </colgroup>
      <tbody>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience (not for high-data-volume
            external objects)</td>

        </tr>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">
            <p>Available in: <strong>Developer</strong> Edition</p>
            <p style="margin-bottom:0;">Available for an extra cost
              in: <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong>
              Editions</p>
          </td>

        </tr>
      </tbody>
    </table>

By default, the OData adapters for Salesforce Connect use client-driven paging. Specifically, the OData requests use the `$top` and `$skip` system query options to page through the result set.

With server-driven paging, the external system determines the page sizes and batch boundaries. The external system’s paging settings can optimize the external system’s performance and improve the load times for external objects in your org. Also, the external data can change while your users or the Lightning Platform are paging through the result set. Typically, server-driven paging adjusts batch boundaries to accommodate changing external data more effectively than client-driven paging.

The Server Driven Pagination field on the external data source specifies whether to use client-driven or server-driven paging. If you enable server-driven paging on an external data source, Salesforce ignores the requested page sizes, including the default `queryMore()` batch size of 500 rows. The pages returned by the external system determine the batches, but each page can’t exceed 2,000 rows. However, the limits for the OData adapters for Salesforce Connect still apply.

#### See Also

- [Define an External Data Source for Salesforce Connect—OData 2.0 or 4.0 Adapter](https://help.salesforce.com/s/articleView?id=platform.platform_connect_add_external_data_source.htm&release=264.0.0&type=5 "Connect your Salesforce org to data that’s stored in an external system, such as SAP® NetWeaver Gateway, Microsoft Dynamics® NAV, or IBM WebSphere®.")
- [Define an External Data Source for Salesforce Connect OData 4.01 Adapter](https://help.salesforce.com/s/articleView?id=platform.odata_add_external_data_source.htm&release=264.0.0&type=5 "Connect your Salesforce org to data that’s stored in an external system, such as SAP® NetWeaver Gateway, Microsoft Dynamics® NAV, or IBM WebSphere®.")
- [General Limits for Salesforce Connect OData Adapters](https://help.salesforce.com/s/articleView?id=platform.odata_general_limits.htm&release=264.0.0&type=5 "Understand the limits for the OData 2.0, 4.0, and 4.01 adapters for Salesforce Connect.")
- [OData Query String Options](https://help.salesforce.com/s/articleView?id=platform.odata_query_string_options.htm&release=264.0.0&type=5 "The OData adapters for Salesforce Connect use a subset of the OData 2.0 and 4.0 and 4.01 system functions and filter expression constructs to query external systems.")