Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Physical Limitations

Physical Limitations Next Page

SQL Anywhere size and number limitations


The following table lists the physical limitations on size and number of objects in a SQL 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
Dbspace size 228 × page size
Temporary file size228 × page size
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)
  • 512 GB for 2 KB pages

  • 1 TB for 4 KB pages

  • 2 TB for 8 KB pages

NetWare (traditional volumes) 4 GB
File size (all other platforms and file systems) 2 GB
Maximum cache size (non-AWE cache) (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 2000 Advanced Server, Windows 2000 Enterprise Server, Windows 2000 Datacenter Server, Windows Server 2003 Enterprise Edition, Windows Server 2003 Datacenter Edition, Windows Vista Ultimate, Windows Vista Enterprise, Windows Vista Business, Windows Vista Home Premium, Windows Vista Home Basic) 2.7 GB
Maximum cache size (AWE cache) (Windows 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, Windows 2000 Datacenter Server, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 Web Edition, Windows Server 2003 Standard Edition, Windows Server 2003 Enterprise Edition, Windows Server 2003 Datacenter Edition ) 100% of all available memory - 128 MB
Maximum cache size (Windows CE) Limited by available memory on the device
Maximum cache size (Unix—Solaris, x86 Linux, AIX, HP) 2 GB for 32-bit servers
Maximum cache size (Win 64) Limited by physical memory on 64-bit servers
Maximum cache size (Unix—Itanium Linux, Itanium HP-UX) Limited by physical memory on 64-bit servers
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 for 32-bit servers

  • ((page size)/8)2 for 64-bit servers

Note: An excessive number of columns, although allowed, will affect performance.

Number of indexes per table 232
Number of rows per database 4096 × 228 ×13
Number of rows per table 4096 × 228
Number of tables per database 232 - 220 - 1 = 4293918719
Number of temporary tables per connection 220 = 1048576
Number of tables referenced per transaction No limit
Number of stored procedures per database 232 - 1 = 4294967295
Number of concurrent statements per database server 20 ×number-of-database-connections+65534
Number of events per database 231 - 1 = 2147483647
Number of triggers per database 232 - 1 = 4294967295
Row size Limited by file size
Table size Maximum file size. User-created indexes for the table can be stored separately from the table
Strings 2 GB
Binary data types 2 GB
Identifiers (including user IDs, table names, and column names)128 bytes
Database server names
  • TCP/IP  250 bytes

  • Shared memory  250 bytes

  • SPX  32 bytes

See -n server option and EngineName connection parameter [ENG].

DEFAULT or COMPUTE expressions (for example, in an ALTER TABLE statement)Limited by page size (page size - 64 bytes)