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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration

Physical limitations on size and number of databases

This topic 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
  • 512 GB for 2 KB pages

  • 1 TB for 4 KB pages

  • 2 TB for 8 KB pages

File size (all other platforms and file systems) 2 GB
Maximum cache size (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) 2.7 GB
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

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 base and global temporary tables per database 232 - 220 - 1 = 4293918719
Number of local 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

Database names

250 bytes

Number of secure feature keys per database server 1000