본문 바로가기
장비&모션제어

파이어버드 DB 데이터 크기 LIMIT 정보

by ictlab 2009. 9. 25.
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