Virtuoso Open-Source Wiki
Virtuoso Open-Source, OpenLink Data Spaces, and OpenLink Ajax Toolkit
Recent Pages
The following pages have been modified recently:
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
|
| |
Per index |
n columns |
maximum |
| |
Per Row |
200 columns |
maximum |
| Columns |
Per table |
n000 columns |
maximum |
| GROUP BY clause |
Maximum length |
| Idenity Length |
Maximum |
100 |
|
| Indexes |
Maximum per table |
Unlimited |
Subject to Global cash on keys |
| LOB Column Length |
Maximum |
2 GB |
|
| Numeric Precision |
Maximum |
40 digits |
| Row Length |
Maximum |
4086 |
| Row in Sorting |
40789 b |
as in tables |
| SQL Statement and Procedure Text |
Maximun |
100K |
| Table Size |
Maximum |
Up to the database size |
|
| VARCHAR Length |
Maximun |
Constrained by max row length when stored into non-LOB column 10 MB inside procedure code |
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 |
