Virtuoso Open-Source Wiki
Virtuoso Open-Source, OpenLink Data Spaces, and OpenLink Ajax Toolkit
Advanced Search
Location: / Dashboard / Main / VOSDBLimits

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
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

Powered By Virtuoso