|
| Name | SQLHELPER_ID_INTERVAL | |
|---|---|---|
| Category | Parameter | |
| Type | long | |
| Access |
R/W(-): Dynamic Read / static Write (online change not possible) |
|
| Group(s) | Database | |
| Description |
When an instance creates an object, it asks the DB to indicate a correct identifier for the newly created object. Because this operation is very frequent, the database provides a pool of identifiers to the instance in order to limit DB SQL request and increase performances. The SQLHELPER_ID_INTERVAL parameter represents the size of the pool of identifiers. All the identifiers belonging to the pool are considered as consumed by the database. So if the instance is stopped, all the identifiers already requested and not yet used by the instance are lost. |
|
| System Instance(s) | rater, updater, guider, bulkLoader, taxer, dispatcher | |
| Default Value | ||
| rater | 10000 |
|
| updater | 10000 |
|
| guider | 10000 |
|
| bulkLoader | 10000 |
|
| taxer | 10000 |
|
| dispatcher | 10000 |
|
| Constraint(s) | ||
| rater |
The parameter must be greater or equal to
1
|
|
| updater |
The parameter must be greater or equal to
1
|
|
| guider |
The parameter must be greater or equal to
1
|
|
| bulkLoader |
The parameter must be greater or equal to
1
|
|
| taxer |
The parameter must be greater or equal to
1
|
|
| dispatcher |
The parameter must be greater or equal to
1
|
|
Document Version: SP04 and later