---
title: "Database parameters in BigPicture 8.33 or lower."
canonical: "https://support.appfire.com/space/DLP/1196524270/Database%20parameters%20in%20BigPicture%208.33%20or%20lower."
format: markdown
---
## **Adjust database parameters**

> 📝 Jira Data Center only.
> 📝 
> 📝 In **BigPicture 8.34 **or higher use the **[sync settings](https://appfire.atlassian.net/wiki/spaces/DLP/pages/958169411)** 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.<br>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  
unnecessarily waste resources on synchronizing it). |
| 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.<br>“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');
```