Specify the number of similarly sized studies per partition
The maximum number of small, medium, and large studies using a single partition is determined by lookups called DME_PARTITION_DEVQC and the DME_PARTITION_PROD. The default settings for both are:
-
Small studies: 20
-
Medium studies: 5
-
Large studies: 1
You can change these values; see Number of studies per partition for details.
For example, if you have a relatively small amount of data in your Development and Quality Control lifecycle areas and a huge amount of data in Production, you might change to settings like:
-
For the Development/QC partition:
-
Small studies: 20
-
Medium studies: 15
-
Large studies: 11
-
-
For the Production partition:
-
Small studies: 10
-
Medium studies: 4
-
Large studies: 1
-
There is a limit to the number of partitions that can be created for a database table: 1024k-1. Each partition can hold any number of records for each study; that is, any number of discrepancies or flags for given study.
Parent topic: Database partitioning