jeephabit3
New Member
Does anyone know if the sequence limits have been changed or removed in version 12?
Starting in the Progress 9.x product, the number of unique sequences supported in a database is determined by Block Size, the formula is:
Maximum Sequence Number = 250 * (Block Size / 1024)
In other words, an application that uses more than 250 sequences will not work on all database block sizes. The number of sequences per database block size are listed below.
Maximum Number Of Sequences
Database Block Size Maximum Number of Sequences
1024 bytes (1K) 250
2048 bytes (2K)) 500
4096 bytes (4K)) 1000
8192 bytes (8K)) 2000
Starting in the Progress 9.x product, the number of unique sequences supported in a database is determined by Block Size, the formula is:
Maximum Sequence Number = 250 * (Block Size / 1024)
In other words, an application that uses more than 250 sequences will not work on all database block sizes. The number of sequences per database block size are listed below.
Maximum Number Of Sequences
Database Block Size Maximum Number of Sequences
1024 bytes (1K) 250
2048 bytes (2K)) 500
4096 bytes (4K)) 1000
8192 bytes (8K)) 2000