Invalid SQL: INSERT INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('fc622fe0797bc15329129817b7bb0288', '54.167.225.62', '1498610360', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1498610360', '0'); (The table 'swsessions' is full)
Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\support.inm.com\includes\functions.php:410) in C:\Inetpub\support.inm.com\includes\functions.php on line 1612
Capacities and Limits of INM VizionDB - Support Center
inm logo
Corporate Website | Contact | Store | Support | Login  
     


Knowledgebase
View categorized listing of all common frequently asked questions.
Downloads
View our categorized library of downloads for all necessary manuals, software, etc.
 Article Options
Support Center » Knowledgebase » INM VizionDB for Director » Capacities and Limits of INM VizionDB
Support Page Banner
 Capacities and Limits of INM VizionDB
Product:Platform:Area:Version:
INM VizionDB for Director All   All

Capacities and Limits

  • INM VizionDB version 4.0 supports projects delivered on CD-ROM or installed to a hard drive. There is no support for accessing the database over a network or for client-server deployment at this time.

  • Multiple INM VizionDB databases can be open at the same time by a single Director movie. However, a INM VizionDB database can only be accessed by one INM VizionDB Database member (you can't have two open Director movies accessing the same INM VizionDB database).

  • Maximum number of indexes per table is 255

  • Maximum size of an index key is 254 bytes

  • Maximum number of conjuncts is 255. A conjunct is a pair of conditions combined with an AND. WHERE F1 = 1 and F2 >= 2 and F2 = 5 is 3 conjuctions, but WHERE F1 = 1 or F2 >= 2 or F2 = 5 is 1 conjunction

  • Maximum size of a table is approximately 50Gb of compressed data, depending on the size of the records. A table with records that compress to 50 bytes can store approximately 50 Gb of compressed data. A table with records that compress to 500 bytes can store approximately 70Gb of compressed data.

  • Table, field and index names are restricted to 31 characters and cannot contain spaces, punctuation or mathematical symbols.

  • The maximum size of a Media or LongVarchar fields is 2Gb.

  • A database can contain no more than 32767 tables.

  • The maximum size for a database is over 30 terabytes.

  • Maximum number of elements in an IN list is 1499. select name from phones where extension in (0000, 0001, 0002 ... 1499)


Article Details
Article ID: 42
Created On: 02 Jun 2006 04:53 PM

 This answer was helpful  This answer was not helpful

inm general footer
Services Xtras Go Products Support Gallery Store Download About Us Contact Newsroom