Virtuoso Database Limits
Physical Database Limits
Item | Type of Limit | Limit Value | Notes |
---|---|---|---|
Database Block Size | Minimum | 2048 bytes | must be a multiple of operating system physical block size |
Database Block Size | Maximum | Operating system dependent | never more than n KB |
Database Size | Maximum for Data | 32 TB | |
Database Size | Maximum for Temp | 32 TB | |
Database file size | Maximum | Operating system dependent | Limited by maximum operating system file size |
Files Per Database | Maximum | Unlimited |
Logical Database Limits
Item | Type of Limit | Limit Value | Notes |
---|---|---|---|
Columns | Maximum per table | n000 columns | maximum |
Columns | Maximum per index | n columns | maximum |
Columns | Maximum per Row | 200 columns | maximum |
GROUP BY clause | Maximum length | ||
Indexes | Maximum per table | Unlimited | Subject to global cache on keys |
Row Length | Maximum | 4086 | |
Row in Sorting | 40789 b | as in tables | |
Table Size | Maximum | Up to the database size | |
LOB Column Length | Maximum | 2 GB | |
VARCHAR Length | Maximum | Constrained by max row length when stored into non-LOB column 10 MB inside procedure code | |
Identity Length | Maximum | 100 | |
Numeric Precision | Maximum | 40 digits | |
SQL Statement and Procedure Text | Maximum | 100K |
Process and Runtime Limits
Item | Type of Limit | Limit Value | Notes |
---|---|---|---|
Locks per Transaction | Maximum | Depends on Memory | 16b per row lock, 60 b per page with at least one row lock |
Virtual Memory | Maximum | Depend on OS | 64 bit pointers on 64 platforms |
Threads | Maximum | Depends on OS | Init File (.ini) specifies cap for pool for SQL client and web server thread pools |
Connections | Maximum | Depends on OS fdset size | At least 2048 and can be set by the license |
Locks | Row-level | Unlimited |
CategoryVirtuoso CategoryOpenSource