RDC has a system setting in the rulesdbo.rdc_system table called Data Keys Limit. This value controls how many individual items (securities or legal entities) are processed within one child event. The default value is set to 10,000.
Using the example of a data strategy that encompasses 25,000 securities, if the data strategy is submitted in non-delta mode, and all securities are processed, you will see three RDC- rule child events submitted in parallel instead of one.
Event 1 processes securities 1 through 10,000,
Event 2 processes securities 10,001 through 20,000
Event 3 processes securities 20,001 through 25,000.
Depending on how many engines are set to run in parallel, and how many data keys fall within any given data strategy, it may be necessary to change this value during implementation to fine-tune performance.
Because this system setting is currently hidden and therefore not available in the RDC Setup System Settings screen, you will need to run the following script directly in the database, replacing 10,000 and ‘USERNAME’ with the desired values.
To run the script directly in the database:
update rulesdbo.rdc_system
set
system_value = 10,000,
update_source = 'USERNAME',
update_date = sysdate
where system_inst = 4
Add Comment