Icon Appendix B - System Capacities

The following is a list of the capacities for the different objects in ElevateDB. Any object that is not specifically mentioned here has an implicit capacity of 2147483647, or High(Integer). For example, there is no stated capacity for the maximum number of roles allowed in a configuration. Therefore, the implicit capacity is 2147483647 roles.

CapacityDetails
Max BLOB Column SizeThe maximum size of a BLOB column is 2GB.
Max CHAR/VARCHAR Column LengthThe maximum length of a VARCHAR/CHAR columns is 1024 characters.
Max Identifier LengthThe maximum length of an identifier is 80 characters.
Max Number of Columns in a TableThe maximum number of columns in a table is 2048.
Max Number of Columns in an IndexThe maximum number of columns in an index is limited by the table's defined index page size.
Max Number of Concurrent SessionsThe maximum number of concurrent sessions for an application or ElevateDB server is 4096.
Max Number of Indexes in a TableThe maximum number of indexes in a table is 512.
Max Number of Jobs in a ConfigurationThe maximum number of jobs in a configuration is 4096.
Max Number of Routines in a DatabaseThe maximum number of routines (procedures and functions combined) in a database is 4096.
Max Number of Rows in a TableThe maximum number of rows in a table is determined by whether global file I/O buffering is enabled in ElevateDB. If global file I/O buffering is enabled, then the maximum number of rows is determined by the maximum file size permitted in the operating system. If global file I/O buffering is not enabled, then the approximate maximum number of rows can be determined by dividing 128GB by the row size.
Max Number of Rows in a TransactionThe maximum number of rows in a single transaction is only limited by the available memory constraints of the operating system and/or hardware.
Max Number of Tables in a DatabaseThe maximum number of tables in a database is 4096.
Max Number of Users in a ConfigurationThe maximum number of users in a configuration is 4096.
Max Row Size for a TableThe maximum row size for a table is 2GB.
Max Scale for DECIMAL/NUMERIC ColumnsThe maximum scale for DECIMAL or NUMERIC columns is 4.
Max Size of an In-Memory TableThe maximum size of an in-memory table is only limited by the available memory constraints of the operating system or hardware.
Min/Max BLOB Block Size for a TableThe minimum BLOB block size is 64 bytes for ANSI databases and 128 bytes for Unicode databases. The maximum BLOB block size is 2GB.
Min/Max Index Page Size for a TableThe minimum index page size is 1 kilobyte for ANSI databases and 2 kilobytes for Unicode databases. The maximum index page size is 2GB.
Image