skip to main content
Connection Option Descriptions : Primary Key Chunk Size
  

Try DataDirect Drivers Now

Primary Key Chunk Size

Attribute

PKChunkSize (PKCS)

Purpose

Specifies the size, in rows, of a primary key (PK) chunk when PK chunking has been enabled via the Enable Primary Key Chunking option. 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. 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. Primary Key Chunk Size 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 Bulk Fetch Threshold and Primary Key Chunk Size options.

Default

100000 (rows)

GUI Tab

Bulk tab

See Also

*Enable Primary Key Chunking
*Bulk Fetch Threshold