Database Limits | ||
Item | Firebird 2.x | Firebird 1.5.x |
| ||
Maximum size of database | Practically unlimited using multiple database files (largest known database is over 980 GB) | 32 TB using multiple files |
| ||
Maximum size of one database file | Multiple terabytes on most platforms; limited by file systems (4 GB or 2 GB on some platforms) | Same |
| ||
Maximum number of database files | 64,535 | Same |
| ||
Maximum number of tables | 64,535 | Same |
| ||
Maximum size of one table | ~32 TB | ~36 GB |
| ||
Maximum size of external table file | 2 GB | Same |
| ||
Maximum number of rows per table | > 16 Billion (not been measured beyond this) | ~4 Billion |
NOTE :: 1 Billion is 1024³ | ||
| ||
Maximum row size | 65,536 bytes (64 KB) | Same |
| ||
Maximum database page size | 16 KB | Same |
NOTE :: Page size (PAGE_SIZE) can be 1024, 2048, 4096, 8192 or 16384. Size 1024 is not recommended. | ||
| ||
Maximum number of columns per table | Depends on data types used. (Example: 16,384 INTEGER (4-byte) values per row.) NOTE :: 8-byte ID is stored for each BLOB or ARRAY reference; size of BLOB or ARRAY data is not counted in row size. | |
| ||
Maximum number of indexes per table | 65,535 | Same |
| ||
Maximum size (total width) of index key | 4,096 bytes when page size is 16 KB (limited to 1/4 of database page size) | 252 bytes |
IMPORTANT :: Limit decreases for character columns when character set is multi-byte; non-binary collation further reduces limit. | ||
| ||
Maximum number of indexes per database | 4,398,046,511,104 | Same |
| ||
'장비&모션제어' 카테고리의 다른 글
아진엑스텍 모션 라이브러리의 보정 테이블 기능 사용 #1/3 (3) | 2012.01.04 |
---|---|
장비 PC의 원격 제어 방법 (3) | 2010.11.05 |
FAT32 , NTFS 파일 크기 제한 (1) | 2009.09.25 |
MS 윈도우 기반 리얼타임OS - InTime (0) | 2009.09.24 |
MS윈도우기반 RTOS - RTX 자료 (0) | 2009.09.24 |