• Topic
  • Discussion
  • VOS.VOSDBLimits(Last) -- DAVWikiAdmin? , 2018-06-20 09:19:21 Edit WebDAV System Administrator 2018-06-20 05:19:21

    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 Row-level Unlimited
    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

    CategoryVirtuoso CategoryOpenSource