The following table lists the physical limitations on size and number of objects in a SQL Anywhere database. Typically, the memory, CPU, and disk drive of the computer are the most limiting factors.
| Item | Limitation |
|---|---|
| Database size | 13 files per database. For each file, the largest file allowed by operating system and file system |
| Dbspace size | 228 x page size |
| Temporary file size | 228 x 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, HP-UX 11.0 and later, Solaris 2.6 and later, Linux 2.4 and later, AIX, Mac OS X |
|
| File size (all other platforms and file systems) | 2 GB |
| Maximum cache size (Windows XP Home Edition, Windows XP Professional, Windows Server 2003 Web Edition, Windows Server 2003 Standard Edition, Windows Server 2008, Windows Server 2008 R2, Windows 7) | 1.8 GB |
| Maximum cache size (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 (Windows Mobile) | Limited by available memory on the device |
| Maximum cache size (Unix—Solaris, x86 Linux, IBM AIX, HP) | 2 GB for 32-bit servers |
| Maximum cache size (Win 64) | Limited by physical memory on 64-bit servers |
| Maximum cache size (Itanium HP-UX) | Limited by physical memory on 64-bit servers |
| Maximum index entry size | No limit |
| Number of databases per server | 255 |
| Number of columns per table |
45000 Note: An excessive number of columns, although allowed, can affect performance. |
| Number of nullable columns per table | min( 45000, ( page size - overhead ) * 8 ) |
| Number of columns in a procedure result set | 45000 |
| Number of columns in a SELECT list | 100000 |
| Number of columns in a GROUP BY list | 100000 |
| Number of columns in a GROUP BY with grouping sets | 64 |
| Number of columns in a CUBE | 15 |
| Number of distinct grouping sets | 32768 |
| Length of DEFAULT for a column | 32768 |
| Length of COMPUTE for a column | 32768 |
| Length of DEFAULT for procedure parameters | 32768 |
| Length of DEFAULT for a user-defined domain | 32768 |
| Length of check constraints | 2 GB |
| Number of indexes per table | 232 |
| Number of rows per database | 4096 x 228 x 13 |
| Number of rows per table | 4096 x 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 x 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 |
| Character data types | 231 - 1 = 2147483647 |
| Binary data types | 231 - 1 = 2147483647 |
| Row size | 45000 fields |
| Array size | 6.4 million elements |
| Identifiers (including user IDs, table names, and column names) | 128 bytes |
| Passwords | 255 bytes |
| Database server names |
250 bytes (TCP/IP and shared memory See -n database server option and ServerName (Server) connection parameter. |
| Database names |
250 bytes See -n database option. |
| Number of secure feature keys per database | 1000 |
SQL Anywhere hardware requirements
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |