ADO.NET Provider for Certinia

Build 25.0.9434

BulkPollingInterval

Specifies the time interval (in milliseconds) between requests that check the availability of a bulk process response.

Data Type

string

Default Value

"500"

Remarks

This property determines the polling frequency, controlling how often the provider sends a request to check the job status. Lower values increase polling frequency, while higher values reduce API calls but may introduce delays in retrieving query results. When UseBulkAPI is set to true, the provider submits asynchronous jobs to Certinia for both bulk query operations (such as SELECT statements) and bulk ingest operations (such as INSERT, UPDATE, or DELETE). The provider then polls the Certinia server at regular intervals to check if the results are ready. Polling is performed for query and ingest responses only when WaitForBulkResults is set to true.

Performance Considerations

Frequent polling (lower values) may result in faster query execution but can increase API usage. A higher polling interval reduces API requests but may lead to slower response times if the query completes and polling is delayed.

This property is useful when fine-tuning performance vs. API consumption when executing bulk queries in Certinia. Adjusting this setting based on query size and API rate limits can help optimize performance.

This setting applies only when Certinia Bulk API is used.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434