Sybase Adaptive Server Anywhere - Size and Number Limitations

Size and number limitations
958
Size and number 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 (NTFS, HP-UX 11.0 and later,
Solaris 2.6 and later)
256 GB (for 1K pages)
512 GB (for 2K pages)
1 TB (for 4K pages)
File size (all other platforms and file
systems)
2 GB
Maximum index entry size No limit
Number of Databases per server 255
Number of columns per table 999 (using 4K pages)
Number of indexes The maximum number of indexes per
table is based on the database page
size:
♦ 4K or less 2048 indexes
♦ 8K 1024 indexes
♦ 16K 512 indexes
♦ 32K 256 indexes
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 – 1 (4294967295)
Number of tables referenced per transaction No limit
Row size Limited by file size
Table size Maximum file size. User-created
indexes for the table can be stored
separately from the table.