Kbase 15348: System Design Limits on V6 PROGRESS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
System Design Limits on V6 PROGRESS
The limits for V6 PROGRESS are dependent on the hardware
and version of the operating system you are using.
Database Limits
Database 200 gigabytes (GB).
Files Constrained by the maximum number of indexes because
each file must have an index.
Indexes Maximum of 1023 per database. No explicit limit
per file.
Maximum of 10 fields per index. Total variable
length storage requirements of all fields in an
index entry must be less than 127 characters
(this includes storage overhead--the actual index
key is limited to approximately 115 characters).
Database Limits
Records Maximum of 32,000 bytes per record. (In practice,
buffer and stack size limitations reduce the maximum
record size to approximately 15,000 bytes.) On
DOS, OS2, XENIX 286, and on BTOS/CTOS machines,
all active records, variables (local, shared,
global), and work files in all active
procedures for a given user must fit in a buffer
area of size 1K-63K bytes. The buffer size can be
up to 4 gigabytes on all other systems.
(See also the Local Buffer
Size (-l) startup option.)
Fields Number per file constrained by record size.
Record Locks Maximum number of records that may be
simultaneously SHARE or EXCLUSIVE locked is
machine dependent, but is at least 2000.
Work Files Minimum record length is 64 bytes.
Data Values
Character Constrained by record size. (If a field has
more than 3000 characters, you must write your
own dump/load procedure because the PROGRESS
dump/load procedure cannot
handle fields larger than 3000 characters.)
Date 1/1/32768 BC through 12/31/32767 AD.
Decimal 50 digits total. Up to 10 decimal places.
Integer -2,147,483,648 through 2,147,483,647.
Logical true/false, yes
o
Number of Users Per Database
Single-user 1
Multi-user The maximum is machine dependent--up to 2048
on UNIX and VMS systems with shared memory,
unless constrained by semaphore limits, process
limits, or machine performance.
For bsd 4.2 without shared memory, Version 7,
UNIX System 3, and XENIX machines, the limit
is the number of file descriptors per process
minus 10. Typically, this means the maximum
number of users is between 10 and 54.
For BTOS/CTOS machines, the maximum number
of users is 64.
Number of Simultaneous Transactions Per Database
Single-user 1
Multi-user One per user (up to the maximum number of
users per database).
Editor
Number of (edit buffer size)/82. The edit buffer can be
Lines sized at 2K-63K on DOS, OS2, BTOS/CTOS, and
XENIX 286 systems and at 2K-4GB for all other
systems. Note that regardless of the size of
the text in a procedure, its compiled .r
version must be smaller than 63K. See also the Edit
Buffer Size (-e) startup option.
Input/Output
Terminal Line
Width UNIX, VMS, BTOS/CTOS: 80 to 132
DOS, OS/2: 80
Printer Line
Width Up to 255
Export File 3000 characters per field,
32K characters per record.
Import File 3000 characters per field,
32K characters per record.
Streams Maximum of 5 named streams per procedure.
Sorting
Levels Maximum of 10 fields or expressions.
Size Maximum of 127 characters in the combined size
of all fields being sorted together.
Names
Procedure UNIX: 1 - 12 characters.
Names DOS, OS/2: 1 - 8 characters.
VMS: 1 - 39 characters.
BTOS/CTOS: 1 - 50 characters.
File, Field, Up to 32 characters in length;
begin with a-z or A-Z;
Index, consist of any combination of letters,
numbers and the
Variable characters # $ % & - _ (The dash (-)
is illegal in PROGRESS/SQL.)
Database UNIX: 1 - 11 characters.
DOS, OS/2: 1 - 8 characters.
VMS: 1 - 39 characters.
BTOS/CTOS: 1 - 12 characters.
Compiler
Variables On DOS, OS2, XENIX 286 and BTOS/CTOS, all
active records, variables (local, shared,
global), and work files in all
active procedures for a given user must
fit in a buffer area of size 1K-63K bytes.
The buffer area can be up to 4GB on all
other systems. (See also the Local Buffer
Size (-l) startup option.)
Statements Maximum of 4000 characters per statement.
Maximum of 1000 tokens per statement.
Each word or special character (left
parenthesis, plus sign, minus sign, for example)
counts as one token.
Frames Maximum width of 255 characters.
Nested Blocks Maximum of 255 blocks, including called
procedures. (See also the Nested Blocks
(-nb) startup options.)
Progress Software Technical Support Note # 15348