When configuring a Database Select Adapter Task in the Business Process, you can choose from Standard Select or Batch Select. This latter option provides enhanced performance for database interactions involving parent/child relationships. By choosing the Batch Select option, you can group parent records into batches, significantly reducing the number of queries required to retrieve the same data.
When selecting the Batch Select option, an additional parameter (Batch Size) appears; this allows you to define how many parent records to process in a single query.
How to use
- In CIC Studio, open the Business Process you're using to call the Database Select Adapter.
- Select the specific task assigned to the Database Select Adapter to optimize.
- Right-click and select Batch Select.
- Define the batchSize parameter (shown below). Note that specific Database types or admin-set limitations may determine batch limits. A value of 500 is set by default.
Adjusting the Batch Size
Begin with the default batch size of 500. If logs indicate the batch size is too large, reduce it incrementally until the logs stop. Note: The batch adapter automatically adjusts to a compatible size if the specified batch size is too large, ensuring no interruption to processing. If no logs appear and faster performance is needed, increase the batch size gradually until logs appear or the desired performance is achieved. - Deploy or redeploy your Project(s) to include the new configuration.
- Monitor your process logs for any warnings, and adjust the batch size if needed.
Notes:
- If the selected batch size is too large, the system logs a warning and automatically retries with smaller batches, halving the size until successful.
- For deeper hierarchies (e.g., parent → child → grandchild), the same batching logic is applied to each relationship level.
- In rare cases where Batch Select does not meet specific join conditions, the Standard Select option is still available for full compatibility.
- Batch Select is currently available only for Database Select Adapters. It does not apply to SQL Access Objects or other operations like INSERT, UPDATE, or DELETE.
- Certain edge cases involving complex joins without detailed conditions may require the Standard Select option.
Related Topic
Comments
0 comments
Please sign in to leave a comment.