...
Use the sequence properties to set up a sequence of unique numbers that you want to allocate to records in a stream,.
To create a sequence, specify a start value and how many numbers you require (the block size). PhixFlow a block size. The block size specifies how often you go back to the database to update the number up to which you have allocated. This is referred to as the 'tidemark'. PhixFlow then allocates those numbers from the database and stores them in memory. When PhixFlow reserves a block it marks the last reserved value in the database.
...
| Field | Description | ||
|---|---|---|---|
| Name | Enter the name of the sequence. | ||
| Start Value | Enter the first value in the sequence. | ||
| Block Size | Enter a number to set the size of the sequence of numbers. This will depend on the number of records in the stream set to which you are allocating unique numbers. For example, if the stream set has 10,000 records, the block size should be at least 10,000.
Block size has an effect on performance; see Block Size and Performance, above. | ||
| Current Value | PhixFlow displays the highest value already allocated. |
...