ASA Database Administration Guide
Physical Limitations
The following table lists the physical 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.
| Item | Limitation |
|---|---|
| Database size | 13 files per database. For each file, the largest file allowed by operating system and file system |
| Field size | 2 Gb |
| File size (FAT 12) | 16 Mb |
| File size (FAT 16) | 2 Gb |
| File size (FAT 32) | 4 Gb |
| File size for NTFS, NetWare (NSS volumes), HP-UX 11.0 and later, Solaris 2.6 and later, Linux 2.4 and later) |
|
| NetWare (traditional volumes) | 4 Gb |
| File size (all other platforms and file systems) | 2 Gb |
| Maximum cache size (non-AWE cache) (Windows 95/98, Windows NT, Windows 2000 Professional, Windows 2000 Server, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 Web Edition, Windows Server 2003 Standard Edition) | 1.8 Gb |
| Maximum cache size (non-AWE cache) (Windows NT Advanced Server, Windows 2000 Advanced Server, Windows 2000 Enterprise Server, Windows 2000 Datacenter Server, Windows Server 2003 Enterprise Edition, Windows Server 2003 Datacenter Edition) | 2.7 Gb |
| Maximum cache size (Windows CE) | 32 Mb |
| Maximum cache size (UNIX—Solaris, x86 Linux, AIX, HP) | 2 Gb for 32-bit engines |
| Maximum cache size (Win 64) | limited by physical memory on 64-bit engines |
| Maximum cache size (UNIX—Tru64 UNIX, Itanium Linux, Itanium HP-UX) | limited by physical memory on 64-bit engines |
| Maximum cache size (NetWare) | 2 Gb |
| Maximum index entry size | No limit |
| Number of databases per server | 255 |
| Number of columns per table |
((page size)/4)^2.
Note: An excessive number of columns, although allowed, will affect performance. |
| Number of indexes |
The maximum number of indexes per table is based on the database page size:
|
| Number of rows per database | Limited by file size |
| Number of rows per table | Limited by file size |
| Number of tables per database | 2^32 - 2^20 - 1 = 4 293 918 719 |
| Number of temporary tables per connection | 2^20 = 1 048 576 |
| Number of tables referenced per transaction | No limit |
| Number of stored procedures per database | 2^32 - 1 = 4 294 967 295 |
| Number of events per database | 2^31 - 1 = 2 147 483 647 |
| Number of triggers per database | 2^32 - 1 = 4 294 967 295 |
| Row size | Limited by file size |
| Table size | Maximum file size. User-created indexes for the table can be stored separately from the table |