skip to main content
Connection Option Descriptions : Enable Primary Key Chunking
  

Try DataDirect Drivers Now

Enable Primary Key Chunking

Attribute

EnablePKChunking (EPKC)

Purpose

Specifies whether the driver uses PK chunking for select operations. PK chunking breaks down bulk fetch operations into smaller, more manageable batches for improved performance.

Valid Values

1 | 0

Behavior

If set to 1 (Enabled), the driver uses PK chunking for select operations when the expected number of rows in the result set is greater than the values of the Bulk Fetch Threshold and Primary Key Chunk Size options. For this behavior to take effect, the Enable Bulk Fetch option must also be set to 1 (enabled).
If set to 0 (Disabled), the driver does not use PK chunking when executing select operations, and the Primary Key Chunk Size option is ignored.

Notes

*PK chunking is supported for all custom objects and the following standard objects: Account, Campaign, CampaignMember, Case, Contact, Lead, LoginHistory, Opportunity, Task, and User. In addition, PK chunking is supported for sharing objects as long as the parent object is supported.

Default

1 (Enabled)

GUI Tab

Bulk tab

See Also

*Bulk Fetch Threshold
*Primary Key Chunk Size
*Enable Bulk Load
*Performance Considerations