Empress Operating Parameters

The following table lists various Empress operating parameters. For practical purposes, sizes are limited by the availability of virtual memory on your system and allowable sizes of files and file systems on your disk, as well as the number of files and directories allowed on your system.

Parameter	Value
Number of Databases	No Empress imposed limit.
Size of Database	A single database may occupy an entire file system. A single database may also span several file systems.
Size of Table (in bytes)	On most machines, this is the size of a 64-bit integer or about 264 bytes.
Size of Record (in bytes)	On most machines, this is the size of a 64-bit integer or about 264 bytes.
Size of Attribute (in bytes)	On most machines, this is the size of a 64-bit integer or about 264 bytes.
Number of Tables/Database	32,767
Number of Attributes/Table	32,767
Number of Keys/Sort	No Empress imposed limit.
Number of Indices/Table	No Empress imposed limit.
Number of Attributes/Index	No Empress imposed limit.
Number of Levels-of-Nesting/Subquery	100