Question
4
Replies
437
Views
NASCO
Posted: June 7, 2017
Last activity: June 8, 2017
Closed
BIX Process is running slow for 1 extract.
We are running multiple extracts from different classes using Get all Properties for XML.
For one of the Extracts which is supposed to be smaller than work object data is taking longer time than Work Class Extract.
For the extract we are using -g and -G parameters to pass pxcommitdatetime filter in the shell script.
The performance of that particular extract seems to be taking longer time to complete.
We are looking into improving the performance of that extract.
Hi Aravind,
From BIX 6.3 onwards, the batch size is the number of work objects which are extracted. A single work object extraction may results in multiple table writes depending on the nested structures chosen in the extract rule.
There is always a trade off between memory and resources when we increase the batch size. When using a large batch size, the JDBC driver will keep those many statements (in this case 39 * batch size * number of records per table) in memory. This is a huge memory consumption. This also means that if a single record in a batch fails, then the whole batch fails and reconciliation could be a big effort considering not all databases work the same way in notifying which record caused the issue.
The above config setting is currently overloaded
1) If the XML is incorrectly generated
2) To avoid declarative processing during extraction
Obviously if the extract rules have properties on which declare expressions have been defined, the above config parameter can significantly reduce the memory consumption specially with large batches.
Hope this helps.
Thanks,
Venkat