informix 10,单表最大记录数有没有限制？
现在一个表有差不多4千万条数据，这算不算多呢？
对性能会不会有什么不良影响？
最差的情况，会不会写不进数据？
回复 #1 euzen 的帖子
有限制，至于限制的记录数具体要看记录结构大小（ROWSIZE)，而且性能也差，分区吧。 限制不是在table有多少條記錄，而是要注意table extent 數量，table 上億的筆數也OK回复 #3 prefect 的帖子
此言差矣~~实际上是有限制的~不过一般都达不到这些数值而已。。
$INFORMIXDIR/release/en_us/0333/ids_xxx_relnotes_xx.xx.txt 里有IDS的限制描述~~
1.9 Limits in IBM Informix Dynamic Server
The following table lists selected capacity limits and system defaults
for this release of IBM Informix Dynamic Server:
+----------------------------------+----------------------------------+
| System-Level Parameters | Maximum Capacity per Computer |
| | System |
+----------------------------------+----------------------------------+
| IBM Informix Dynamic Server | 255 |
| systems per computer (Dependent| |
| on available system resources) | |
+----------------------------------+----------------------------------+
| Maximum number of accessible | Machine specific |
| remote sites | |
+----------------------------------+----------------------------------+
+----------------------------------+----------------------------------+
| Table-Level Parameters (based on | Maximum Capacity per Table |
| 2K page size) | |
+----------------------------------+----------------------------------+
| Data rows per fragment | 4,277,659,295 |
+----------------------------------+----------------------------------+
| Data pages per fragment | 16,775,134 |
+----------------------------------+----------------------------------+
| Data bytes per fragment | 33,818,671,136 |
| (excludes Smart Large Objects | |
| (BLOB, CLOB) and Simple Large | |
| Objects (BYTE, TEXT) created in| |
| Blobspaces) | |
+----------------------------------+----------------------------------+
| Binary Large Object BLOB/CLOB | 4*2*40 |
| pages | |
+----------------------------------+----------------------------------+
| Binary Large Objects TEXT/BYTE | 4*2*40 |
| bytes | |
+----------------------------------+----------------------------------+
| Row length | 32,767 |
+----------------------------------+----------------------------------+
| Number of columns | 32K |
+----------------------------------+----------------------------------+
| Key parts per index | 16 |
+----------------------------------+----------------------------------+
| Columns per functional index | 102 (for C UDRs) 341 (for SPL|
| | or Java UDRs) |
+----------------------------------+----------------------------------+
| Bytes per index | 390 |
+----------------------------------+----------------------------------+
+----------------------------------------------+----------------------+
| Access Capabilities | Maximum Capacity per |
| | System |
+----------------------------------------------+----------------------+
| Maximum databases per Dynamic Server system| 21 million |
+----------------------------------------------+----------------------+
| Maximum tables per Dynamic Server system | 477,102,080 |
+----------------------------------------------+----------------------+
| Maximum active users per Dynamic Server | 32K user threads |
| (minus the minimum number of system threads) | |
+----------------------------------------------+----------------------+
| Maximum active users per database and table| 32K user threads |
| (also limited by the number of available | |
| locks, a tunable parameter) | |
+----------------------------------------------+----------------------+
| Maximum number of open tables per Dynamic | Dynamic allocation |
| Server system | |
+----------------------------------------------+----------------------+
| Maximum number of open tables per user and | Dynamic allocation |
| join | |
+----------------------------------------------+----------------------+
| Maximum locks per Dynamic Server system and| Dynamic allocation |
| database | |
+----------------------------------------------+----------------------+
| Maximum number of page cleaners | 128 |
+----------------------------------------------+----------------------+
| Maximum number of recursive synonym mappings | 16 |
+----------------------------------------------+----------------------+
| Maximum number of tables locked with LOCK | 32 |
| TABLE per user | |
+----------------------------------------------+----------------------+
| Maximum number of cursors per user | Machine specific |
+----------------------------------------------+----------------------+
| Maximum chunk size (for platforms with 2K| 4 Terabytes |
| page size; values might be higher for | |
| platforms with 4K page size) | |
+----------------------------------------------+----------------------+
| Maximum number of 2K pages per chunk | approx. 2GB |
+----------------------------------------------+----------------------+
| Maximum number of open Simple Large Objects| 20 |
| (applies only to TEXT and BYTE data types) | |
+----------------------------------------------+----------------------+
| Maximum number of B-tree levels | 20 |
+----------------------------------------------+----------------------+
| Maximum amount of decision support memory | Machine specific |
+----------------------------------------------+----------------------+
IBM Informix Dynamic Server System Defaults
+----------------------------------+----------------------------------+
| Table lock mode | Page |
+----------------------------------+----------------------------------+
| Initial extent size | 8 pages |
+----------------------------------+----------------------------------+
| Next extent size | 8 pages |
+----------------------------------+----------------------------------+
| Read-only isolation level (with| Committed Read |
| database transactions) | |
+----------------------------------+----------------------------------+
| Read-only isolation level | Repeatable Read |
| (ANSI-compliant database) | |
+----------------------------------+----------------------------------+
ON-Monitor Statistics
+----------------------------------+----------------------------------+
| Number of displayed user threads | 1000 |
+----------------------------------+----------------------------------+
| Number of displayed chunks | 1000 |
+----------------------------------+----------------------------------+
| Number of displayed dbspaces | 1000 |
+----------------------------------+----------------------------------+
| Number of displayed databases | 1000 |
+----------------------------------+----------------------------------+
| Number of displayed logical logs | 1000 |
+----------------------------------+----------------------------------+ 受教了
老大是還早的版本啊
我的 9.4 UC8 是
1.10 Limits in IBM Informix Dynamic Server
10 FC6 是
1.11 Limits in IBM Informix Dynamic Server
說實話 從來沒有好好看過這裏面的東東 回去好好看看 extends是个问题，需要关注的。否则插入数据真可能出错
页:
[1]