Size and number limitations

Reference Manual
CHAPTER 13. Physical Limitations

Size and number limitations

The following table lists the limitations on size and number of objects in Adaptive Server Anywhere database. The memory, CPU, and disk drive of the computer are more limiting factors in most cases.

In some cases, the Windows NT operating system using the NTFS file system has different limits. These are indicated.

Item

Limitation

Database size

2 GB per file, 12 files per database

Database size (NTFS file system)

12 files per database. For each file, the largest file allowed by operating system.

Number of tables per database

32,767

Number of tables referenced per transaction

No limit

Table size

2 GB—must be in one file. User-created indexes for the table can be stored separately from the table.

Table size (NTFS file system)

Maximum file size. User-created indexes for the table can be stored separately from the table.

Number of columns per table

999 (using 4K pages)

Number of rows per table

Limited by table size

Row size

Limited by table size

Number of rows per database

Limited by file size

Field size

2 GB

Number of indexes

32,767 per table

Maximum index entry size

No limit

Item	Limitation
Database size	2 GB per file, 12 files per database
Database size (NTFS file system)	12 files per database. For each file, the largest file allowed by operating system.
Number of tables per database	32,767
Number of tables referenced per transaction	No limit
Table size	2 GB—must be in one file. User-created indexes for the table can be stored separately from the table.
Table size (NTFS file system)	Maximum file size. User-created indexes for the table can be stored separately from the table.
Number of columns per table	999 (using 4K pages)
Number of rows per table	Limited by table size
Row size	Limited by table size
Number of rows per database	Limited by file size
Field size	2 GB
Number of indexes	32,767 per table
Maximum index entry size	No limit