Database parameters in BigPicture 8.33 or lower
- Anna Ciepłota
Adjust database parameters
Jira Data Center only.
In BigPicture 8.34 or higher use the sync settings to make adjustments.
The sync mechanisms are controlled by the following parameters set in the BigPicture database.
Active boxes are defined based on the following parameters:
box activity threshold
active box limit
Parameter | PartialSyncRecentActivityHourThreshold | ||
|---|---|---|---|
Description | If a box has been visited within the last X hours, it is considered as a “box visited recently” (changes that affect it will be processed by the high-priority queue). Other boxes will be considered as a “box not visited recently” (changes that affect them will be processed by the low-priority queue). | ||
Values | Default = 12 hours | Min = 1 hour | Max = 144 hours |
Parameter | PartialSyncHighPriorityGroupMaxSize | ||
|---|---|---|---|
Description | Limit of boxes supported by the high-priority queue. If BigPicture detects that the high-priority queue is to handle too many boxes, then to improve its performance only the last X boxes will be left in the queue (the low-priority queue will handle the remaining boxes). | ||
Values | Default = 30 boxes | Min = 10 boxes | Max = 100 boxes |
Specify what falls into the high-priority queue and adjust the timeout threshold for box synchronization:
Parameter | PartialSyncExecutionTimeMillisThreshold | ||
|---|---|---|---|
Description | If the box synchronization time exceeds X milliseconds (for the last 2 days) then the box will be handled by the low-priority queue. This parameter is intended to improve the operation of the high-priority queue, by removing changes related to the BigPicture box that is in full synchronization process (so the high-priority queue would | ||
Values | Default = 2000 millisec. | Min = 500 millisec. | Max = 10000 millisec. |
Enables high and low priority queues:
Parameter | PartialSyncPrioritizedQueueEnabled | ||
|---|---|---|---|
Description | "true" enables the division into high-priority and low-priority queues. “false” disables the new mechanism (Partial Sync process works as in previous versions). | ||
Values | Default = true | Min = true | Max = false |
Parameter | PartialSyncLowPriorityQueueDisabled | ||
|---|---|---|---|
Description | “false” causes the low-priority queue to be enabled. “true” causes the low-priority queue to be disabled. In such a situation, boxes considered as “boxes not visited recently” will not have a regularly updated structure. The structure update will be performed when the user enters such a box (this may take some time). | ||
Values | Default = false | Min = true | Max = false |
Example of a database entry:
insert into "AO_0456E7_PROPERTY" ("CONVERTER_NAME", "SCOPE_LEVEL1",
"TECH_UNIQUENESS", "VALUE")
values ('StringConverter',
'PartialSyncPrioritizedQueueEnabled', 'PartialSyncPrioritizedQueueEnabled', 'true'),
('StringConverter',
'PartialSyncLowPriorityQueueDisabled', 'PartialSyncLowPriorityQueueDisabled', 'false'),
('StringConverter',
'PartialSyncExecutionTimeMillisThreshold', 'PartialSyncExecutionTimeMillisThreshold',
'2000'),
('StringConverter',
'PartialSyncHighPriorityGroupMaxSize', 'PartialSyncHighPriorityGroupMaxSize', '30'),
('StringConverter',
'PartialSyncRecentActivityHourThreshold', 'PartialSyncRecentActivityHourThreshold', '12');