![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Data Access Components Manual » Appendix » Appendix B - System Capacities |
Capacity | Details |
Max BLOB Column Size | The maximum size of a BLOB column is 2GB. |
Max CHAR/VARCHAR Column Length | The maximum length of a VARCHAR/CHAR columns is 1024 characters. |
Max Identifier Length | The maximum length of an identifier is 80 characters. |
Max Number of Columns in a Table | The maximum number of columns in a table is 2048. |
Max Number of Columns in an Index | The maximum number of columns in an index is limited by the table's defined index page size. |
Max Number of Concurrent Sessions | The maximum number of concurrent sessions for an application or ElevateDB server is 4096. |
Max Number of Indexes in a Table | The maximum number of indexes in a table is 512. |
Max Number of Jobs in a Configuration | The maximum number of jobs in a configuration is 4096. |
Max Number of Routines in a Database | The maximum number of routines (procedures and functions combined) in a database is 4096. |
Max Number of Rows in a Table | The 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 Transaction | The 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 Database | The maximum number of tables in a database is 4096. |
Max Number of Users in a Configuration | The maximum number of users in a configuration is 4096. |
Max Row Size for a Table | The maximum row size for a table is 2GB. |
Max Scale for DECIMAL/NUMERIC Columns | The maximum scale for DECIMAL or NUMERIC columns is 4. |
Max Size of an In-Memory Table | The 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 Table | The 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 Table | The minimum index page size is 1 kilobyte for ANSI databases and 2 kilobytes for Unicode databases. The maximum index page size is 2GB. |
This web page was last updated on Monday, February 20, 2023 at 07:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |