|
For the most inquisitive among you, following is a list of data-related system capacities as supported by Alventis.
| • | The maximum number of tables in a database is 4096. |
| • | The maximum number of records in a table is 200 million. |
| • | The maximum record size is 65280 bytes (this does not take BLOB fields into account). |
| • | The maximum number of fields in a table is 1024. |
| • | The maximum number of BLOB fields in a table is 128. |
| • | The maximum size of a BLOB field is 2 gigabytes. |
| • | The maximum length of a string field is 512 bytes. |
| • | The maximum size of the each of the physical files that make up a table (TableName.dat, TableName.idx, and TableName.blb), is 4,000,000,000 bytes. |
| • | The maximum length of a database name is 60 bytes. |
| • | The maximum length of a table name is 60 bytes. |
| • | The maximum length of a table description is 100 bytes. |
| • | The maximum length of a field name is 60 bytes. |
| • | The maximum length of a field description is 100 bytes. |
|
