Derived and Market-Data Truncation Optimization

Truncation represents the periodic removal of market data and derived data from the RAPCache database at the point it reaches a predefined age.

Use the Operations Console to create truncation rules. See the RAP – The Trading Edition Operations Console Users Guide.

• Increasing Operations Console Data-Truncation Performance
  Improve data-truncation performance of the Operations Console.
• Modifying Market and Derived-Data Schema
  The schema that represents the market and derived data in the RAPCache database can significantly affect truncation performance.
• Creating User-Defined Execution Classes
  Truncating data is a CPU-intensive activity that involves the interaction of the RAPCache database with the Operations Console, the RAPCache database Job Scheduler, and processes created by the RAPCache database Job Scheduler.
• Additional Parameters
  Several configuration parameters impact truncation performance.
• Granting RAPCache Database User Permissions
  User accounts that are used to truncate data must be granted certain roles and permissions.