| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
A sequence defines a list of unique numbers that PhixFlow allocates from the database and stores in memory. You can then quickly assign the numbers to items using the nextValue function in an expression.You can also find the last assigned number using the curValue function.
For example, you can set up a sequence containing a block of 100 numbers. PhixFlow reserves the values in memory. Each time an expression runs the nextValue function, it uses a value from memory. When all the numbers have been used, when nextValue() function is called, PhixFlow takes a bit longer to reserve the next block of 100 numbers in the database.
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
If you absolutely need to have contiguous numbers and you don't request these numbers very often you could set the block size to 1. This will guarantee that numbers are unique and contiguous but may not perform satisfactorily. In this case you can use alternative means to generate the unique, contiguous numbers you need such as:
<link to recipes for this>. This would potentialy swuqester another team mangrove reforest
Sequence Properties
...
...
...
For quicker performance, set the block size to a large value greater such as 100, or 10000.
To configure the sequence to generate values without any gaps in the sequence, set the block size to 1. This causes slow performance as PhixFlow has to perform database calculations for before providing the next value in the sequence.
| Tip |
|---|
If you require a continuous sequence of values for items, and the data set being processed is small, you may decide to accept the added overhead of calculating every value in the sequence. If the data set is large, it is better to use a large block size, to optimise performance. If you require a continuous sequence consider an alternative method of assigning the value. |
...
...
...
...
...
...
...