English French German Spain Italian Dutch Russian Portuguese Japanese Korean Arabic Chinese Simplified

Progress Limits

.

The limits for PROGRESS are determined by the hardware and version of the operating system you are using. The limits also differ slightly between Full PROGRESS and the PROGRESS Test Drive.

This chapter list the PROGRESS limits you might have to know when developing a PROGRESS application.The limits are described in the following categories :

· Database limits

· Data values

· Number of users per database

· Number of simultaneous transactions per database

· Procedure Editor limits

· Input /output limits

· Sorting limits

· Character limits for names

· Compiler limits

Database Limits

This section lists the database limits.PROGRESS limits the size of a database by :

· Block size

· Element size

· Multi-volume files

Block size

The database block size determines how large your database can be. The following table lists the maximum database size by block size

Block size Maximum database size

512 bytes 32 GB

1,024 bytes (1K) 64 GB

2,048 bytes (2K) 128 GB

4,096 bytes (3K) 256 GB

Element size

PROGRESS limits the size of each database element. The following table lists each element and maximum size

Element

Limit

Tables

Maximum table size is the same as the maximum database size (since a database can hold only one table). See the Block Size Limits table

Indexes

Maximum number of indexes per database depends on the block size.

Block Size Maximum Indexes

512 2,048

1024 4,096

2048 8,192

4096 1,6384

There is no explicit limit per file

Index Entry

Maximum of 16 fields per index.Totel variable-length storage requirement of all fields ain an index entry must be less than 200 characters (including storage overhead-the actual index key is limited to approximately 188 characters).

Records

1-32,000 bytes per record. (In practice buffer and stack size limitations reduce the maximum record size to approximately 15,000 bytes).

Fields

Number per table constrained by record size

Record locks

Maximum number of records that can be simultaneously SHARE or EXCLUSIVE locked depends on the value of the Lock Table Entries (-L) parameter

Worktable

Minimum record length is 64 bytes. Limited by available memory

PROGRESS limits maximum database file size to 2GB on most operating systems. Thus, you cannot have a single-volume database larger than 2GB. To surpass this limit, use a multi-volume database. The following table lists each operating system and its maximum database file size.

Operating system

Maximum Database File Size

UNIX

2GB or system limit (whichever is smaller)

DOS

8MB (performance issues)

OS/2 and NT

2GB

VMS

2GB

CTOS

2GB

Multi-volume File

The size of a multi-volume is limited b the file size limits specified in the preceding table.The maximum number of multi-volume files per database is 256

Data Values

The following table lists the data value limits

Data Type

Limit

CHARACTER

Constrained by record size. (If a field has more than 3,000 characters, you must write your own dump/reload procedure cannot handle fields larger than 3,000 character

DATE

1/1/32768 B.C. to 12/31/32767 A.D.

DECIMAL

50 digits total; 1 to 10 decimal places

INTEGER

-2,147,483,648 to 2,147,483,647

LOGICAL

TRUE/FALSE, YES/NO

Number of Users per Database

The following table lists the maximum number of users per database

Database Type

Limit

Single-user

1

Multi-user

Maximum is machine dependent-up to 2,048 on UNIX,NT, OS/2, and VMS systems with shared memory, unless constrained by semaphore limits, process limits, or machine performance.

On CTOS, the number of users is 64.

Number of Simultaneous Transactions per Database

The following table lits the maximum number of simultaneous transantions per database

Database Type

Limit

Single-user

1

Multi-user

1 per user (maximum users = 2,048)


Procedure Editor Limits

The following table lists Procedure Editor Limits

Category

Limit

Number of buffers

Limited by system memory

Buffer size

Character mode : 32,767* charsPerLine=memoryLimit OSF/Motif: system memory

MS-Windows: system memory

Inout/Output Limits

The following table lists the maximumt number of characters for input and ouput devices.

Device

Limit

Terminal line width

UNIX, VMS, CTOS: 80 to 132 characters

NT/DOS/OS/2: 80 characters

Printer line width

1 to 255 characters

Export file

1 to 3,000 characters per field; 32K characters per record

Import file

1 to 3,000 characters per field; 32K characters per record

Streams

1 to 5 streams per procedure

Sorting Limits

The following table lists the sorting limits

Category

Limit

Levels

1 to 16 fields or expressions

Size

1 to 197 characters per entry in the combined size of all fields being sorted together (numOfKeys+lengthOf Key <= 198)


Character Limits for Names

The following table lists the maximum number of characters you can have in names.

Name Type

Operating System

Limit

External procedure

UNIX

DOS, Windows, OS/2, NT

VMS

CTOS

1 to 12 characters

1 to 8 characters, plus an optional .p extension.

1 to 39 characters

1 to 50 characters

Table

Field

Field-level widget

Index

Variable

Run-time procedure parameter

All

1 to 32 characters; beginning with a-z or A-Z; can consist of any combination of letters, number, and these special character: # $ % % & - _

The dash(-) is not allowed ain PROGRESS/SQL

Internal procedure

Block label

Frame widget

Browse widget

Menu widget

Submenu widget

Menu item widget

All

No set limit; beginning with a-z or A-Z; can consist of any combinations of letters, numbers, and these special characters: # $ % & - _

Stream

All

1 to 12 characters; beginning with a-z or A-Z; can consist of any combinations of letters, numbers, and these special characters: # $ % & - _

Database

UNIX

DOS, OS/2, NT, Windows

VMS

CTOS

1 to 11 characters, excluding any directories you name before the database name. You cannot use a file extension

1 to 8 characters, excluding any directories you name before the database name. You cannot use a file extension

1 to 39 characters, excluding any directories you name before the database name. You can use a maximum of 64 characters including both the directory specification and file name. You can use a file extension

1 to 12 characters

Pathnames

UNIX

DOS, OS/2, NT, Windows

VMS

CTOS

1 to 60 characters

1 to 63 characters

1 to 64 characters, including both directory specifications and file name

1 to 92 characters

Compiler Limits

The following table lists the limits for each element of the Compiler

Element

Limit

Variables

32K for UNDO variables and 32k for NO-UNDO variables per external procedure. 32K for local UNDO variables and 32K for local NO-UNDO variables per internal procedure or trigger block

Statements

1 to 8,000 characters per statement settable with the input Characters(-inp) parameter. 1 to 2,000 tokens per statement settable with the Token(-tok) parameter. Each word or special character, such as a parenthesis, plus sign, and minus sign, counts as one token

Frames

1 to 320 characters

Nested blocks

1 to 255 blocks, including called procedures, See also the Nested Blockd(-nb) parameter

lintasberita

Share |

10 comments:

rasiqzone Balas Komentar mengatakan...

ilmu yang berharga sobat..
keep posting..
happy blogging..

Nabil Muhammad F Balas Komentar mengatakan...

Maksudny gimana ini bang rendy. Wah, bingung nih...

Imoel Balas Komentar mengatakan...

waduh.. kelihatannya postingan ini bagus banget.. tapi aku kurang ngerti dengan bahasa inggris, jadi ga' mudeng to..

BeDa Balas Komentar mengatakan...

Nice information about progress limit

Salam ukhuwah

ekoya Balas Komentar mengatakan...

nice artikel sob

manajubelz Balas Komentar mengatakan...

NICE INFO GAN!!!

Imoel Balas Komentar mengatakan...

progress limit is very good article..

Riky Rizkiyana Balas Komentar mengatakan...

agak sdikit mumet, tapi thnks inponya gan ..

secangkir teh dan sekerat roti Balas Komentar mengatakan...

maksudnya bagaimana?

Dwi_Teguh' bLog Balas Komentar mengatakan...

waduhhhh.....aku gak ngerti karena pakek bhs inggRis nie

Posting Komentar

Jangan Lupa Tinggalkan Komentar anda Untuk Perbaikan Blog Ini!


Bila Anda Bingung Gunakan Tombol TAB

Silakan Pasang Link Anda Di Bawah Ini Dan Jangan Lupa Pasang Balik Link saya.
Thanks,
Recent Comment And Contact Us
foxyform.com
 
Selamat datang di Rendy'site | Terimah kasih atas kunjungannya. Tanbahkan komentar dan saran anda untuk perubahan yang lebih baik pada blog ini !