skip to main content
Connection Property Descriptions : PKChunkSize
  

Try DataDirect Drivers Now

PKChunkSize

Purpose

Specifies the size, in rows, of a primary key chunk when PK chunking has been enabled via the EnablePKChunking property. The Salesforce Bulk API splits the query into chunks of this size.

Valid Values

x
where:
x
is a positive integer less than or equal to 250,000 rows.

Behavior

The driver requests, via the Salesforce Bulk API, that Salesforce divide the query into chunks of this size.

Notes

*Fewer rows may be returned if a WHERE clause has been applied to the fetch operation, or if soft-deleted records are included within the boundaries of a given chunk.
*Each chunk is processed as a separate batch that counts toward your daily batch limit. Larger chunks will result in fewer batches, but may reduce performance. PKChunkSize may be set to a maximum value of 250,000 rows.
*For PK chunking to be used in select operations, the expected number of rows in the result set must be greater than the values of the BulkFetchThreshold and PKChunkSize properties.

Data Source Method

setPKChunkSize

Default

100000 (rows)

Data Type

long

See also

*EnablePKChunking
*BulkFetchThreshold