The following table lists the limitations on size and number of objects in an IQ database. The memory and disk drive of the computer are more limiting factors in most cases.
Item |
Limitation |
|---|---|
Database size |
Dbspace size multiplied by the number of files. Upper limit is typically 8PB. |
Dbspace size |
Raw: No limit (as large as the device allows) Operating system files: 4TB |
Catalog file size |
Maximum is 1TB for all platforms except for Windows systems with FAT 32 file systems which have a 4GB limit. Windows systems with NTFS support the 1TB maximum. |
Number of files per database |
Operating system limit that user can adjust (for example, using NOFILE). Typically, 2047 files per database. |
Number of tables per database |
32,767 |
Number of tables referenced per transaction |
No limit |
Number of tables or views referenced per query |
128 |
Number of UNION branches per query |
128. (If each branch has multiple tables in its FROM clause, the limit on tables per query reduces the number of UNION branches allowed.) |
Number of tables or views in a single FROM clause |
16 to 64, depending on the query, with join optimizer turned on |
Table size |
Limited by database size |
Number of columns per table |
IQ supports up to 45,000 columns in a table. There may be performance penalties with more than 10,000 columns in a table |
Number of rows per table |
Limited by table size, upper limit 127 billion |
Row size |
Sybase recommends a limit of half the page size |
Field size |
255 bytes for most data types (32,767 for CHAR, VARCHAR, BINARY, or VARBINARY) |
Maximum length of variable-length FILLER column |
512 bytes |
Number of indexes |
32,767 per table |
Maximum key size |
255 bytes for single-column index 5300 bytes for multicolumn index |
Number of tables per join index (number of tables that can be joined in one query block) |
32 |
Number of values in an IN list |
250,000 |
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 |
IQ page size |
Must be between 64KB and 512KB |
Maximum number of users (connected and concurrent) |
1000 on 64-bit platforms (AIX, Sun Solaris, and HP) 200 on 32-bit platforms (Linux and Windows) |
Maximum size of temp extract file |
Set by TEMP_EXTRACT_SIZEn option. Platform limits are: AIX & HP-UX: 0 - 64GB Sun Solaris: 0 - 512GB Windows: 0 - 128GB Linux: 0 - 512GB |
