Q: What are the limits on data elements within DBMaker?

A:
  • Maximum number of rows per table: No Limit
  • Maximum number of tables per database: No limit
  • Maximum number of tablespaces per database: 32767
  • Maximum number of devices: 32767
  • Maximum storage capacity: 70 TB
  • Maximum row size (excluding BLOB & FO columns): 3992 bytes
  • Maximum number of columns per table: 252
  • Maximum number of columns per index: 16
  • Maximum number of journal files per database: 8
  • Maximum length of table/column name: 18 bytes
  • Maximum number of tables per join: 31
  • Maximum number of savepoints per transaction: 32
  • Maximum cache memory: 2GB .