Question
Accenture
US
Last activity: 20 Jun 2018 0:03 EDT
BIX Batch size
We are calling Exract rule through activity Rule-Admin-Extract. pxExtractDataWithArgs. This runs in a batch of 30 records from PRPC database and our BIX rule is configured to run as Database schema.
Where is the number of records configured that it picks in one batch and how can we change it?
Example:
2018-06-16 15:22:46,840 [PRPCWorkManager : 39] [] ( internal.access.ExtractImpl) INFO - Target database using batch inserts
2018-06-16 15:22:47,529 [PRPCWorkManager : 39] [] ( internal.access.ExtractImpl) INFO - # Instances Retrieved till this batch: 30 -- 00.20% Complete - Last Id Processed in this Batch Execution: I-30
2018-06-16 15:22:47,670 [PRPCWorkManager : 39] [] ( internal.access.ExtractImpl) INFO - # Instances Retrieved till this batch: 60 -- 00.40% Complete - Last Id Processed in this Batch Execution: I-60
***Edited by Moderator Marissa to update platform capability tags***
Aaseya IT Services PVT LTD
IN
You can use the command line argument "-b" to change it
Set pyArgs before you are invoking the pxExtractDataWithArgs
Param.pyArgs = "-b 50"
-b
Specify the batch size (the number of extracted class instances) for commits to a relational database.
This option only applies to databases with JDBC drivers that support batch updates.
Note: This option is not available when running an Extract rule on the cloud.