Skip to main contentCúram Performance & Tuning Guide

Common DB configuration and tuning

The following maintenance and database design guidelines apply to tuning across all supported databases.

Database tuning provided in this guidance is not comprehensive.

However, the following values are a starting point for how to configure a performant database for Cúram. It is our recommendation that project teams verify their own tuning, and where necessary adapt and expand the configuration based on their own requirements prior to going in to production.

Foreign key constraints

As outlined in Creating the Production Database in the Application in the Operations Guide:

  • Omit foreign key constraints as they are not supported in a production environment

    Note: The Cúram Reference Application enforces referential integrity (RI) in the application and as such using database-enforced RI will degrade performance. It is strongly recommended that in a production environment you do not create foreign key constraints on your database.

Previous
Overview: Assumptions
Next
Database Configuration: Db2