WARNING! This URL (in the Main cluster) is no longer the authoritative source for this page; it has been moved to the VOS or ODS cluster as appropriate instead.
See Tim Haynes in case of confusion.
Virtuoso Database Limits
General
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 |
|
Maximum |
Operating system dependent |
never more than n KB |
Database Size |
Maximum |
32 TB for Data |
|
|
|
32 TB for Temp |
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 |
Per table |
n000 columns |
maximum |
|
Per index |
n columns |
maximum |
|
Per Row |
200 columns |
maximum |
GROUP BY clause |
Maximum length |
Indexes |
Maximum per table |
Unlimited |
Subject to Global cash 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 |
Maximun |
Constrained by max row length when stored into non-LOB column 10 MB inside procedure code |
Idenity Length |
Maximum |
100 |
|
Numeric Precision |
Maximum |
40 digits |
SQL Statement and Procedure Text |
Maximun |
100K |
Process and Runtime Limits
Item
|
Type of Limit
|
Limit Value
|
Notes
|
Locks |
Row-level |
Unlimited |
|
Locks per Transaction |
Maximim |
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) specifieds cap for pook 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 |