Kbase P34608: How many sequences can a database hold?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/06/2010 |
|
Status: Verified
GOAL:
What are the maximum number of sequences allowed ?
GOAL:
How many sequence objects can be defined ?
GOAL:
Is there a limit for the number of sequences in a database?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
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