• Topic
  • Discussion
  • VOS.VOSDBLimits(Last) -- DAVWikiAdmin? , 2017-06-13 05:45:21 Edit WebDAV System Administrator 2017-06-13 01:45: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
    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

    CategoryVirtuoso CategoryOpenSource