2.1.4.Limits

The below table lists the most important parameters and limits for a database or a Virtuoso server instance. For space consumption of individual data types, see Space Consumption .

Table2.1.Limits

Limit Description Value
Identifier length 100
User name and password length 100
SQLstmt and proc text 100K+
varchar length Constrained by max row length when stored into non-LOB column, 10MB inside procedure code.
Numeric precision Max 40 digits
LOB column length 2GB
row length 4086
Columns per row 200
Database size 32TB for data, 32TB for temp data
Page size 8K
File size 64 bit file offsets on supporting OS's
Files per database unlimited
Table size Up to database size
Tables per database 64K keys, a table takes 1 key for primary key, 1 key per index and 1 key for each obsolete primary key layout resulting from adding or dropping columns.
Indexes per table Unlimited, subject to global cap on keys.
Row in sorting/distinct temp 4078b, as in tables
Locks per transaction Depends on memory, 16b per row lock, 60b per page with at least one row lock.
Changes per transaction Depends on memory, ini parameter allows cap on rollback before image.
Virtual memory> Depends on OS, 64 bit pointers on 64 bit platforms
Threads Depends on OS, ini files specifies cap for pool for SQL client and web server worker thread pools.
Max connections Depends on OS fdset size, at least 2048, license can set a limit
Memory per connection 22K plus up to 100 cached SQL statement compilations