장비&모션제어
파이어버드 DB 데이터 크기 LIMIT 정보
ictlab
2009. 9. 25. 18:14
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 |
| ||