Primary Key Chunking At This Many Records

PKChunkThreshold

Key Name	Default Value	Required
PKChunkThreshold	100000	No

Description

The number of query results at which the connector starts to use the Bulk API with primary key chunking for data retrieval.

The connector uses primary key chunking only when all of the following requirements are met:

• The query can be executed with primary key chunking.
• The Enable Bulk API QueriesEnableBulkQuery option must be enabled.
• The Enable Primary Key ChunkingEnablePKChunking option is enabled.
• The number of results is greater than or equal to the value specified for the Bulk API Query At This Many RecordsBulkQueryThreshold option.
• The number of results is greater than or equal to the value specified for the Primary Key Chunking At This Many RecordsPKChunkThreshold option.

If data retrieval fails, then the connector falls back to using the REST API to retrieve the data.

Related topics

• Enable Primary Key Chunking
• Primary Key Chunk Size
• Enable Bulk API Queries
• Advanced Driver Configuration Options on page 1
• Configuring Advanced Options
• Creating a Data Source Name
• Configuring a DSN-less Connection
• Using a Connection String