"АТ" <49426@users.rsdn.ru> wrote in message news:1773752@news.rsdn.ru...
> А существует ли спецификация по ограничениям Firebird 1.5?
> Очень нужна информация по максимальному количеству одновременных
> подключений к базе данных и т.п. Пока смог найти только
> "http://firebird.sourceforge.net/guide/FBFactsheet.html"
> Но там мало цифр.

Вот (из Research paper by Herausgeber und Urheber Fabalabs Software GmbH, Honauerst. 4 A-4020 Linz):

Firebird 1.5.2:

DB Limits:
Maximum number of tables: 32767
Maximum database size: Theoretical limit of 7 TB
Maximum number of files per database: Theoretically 65536 (2^16) including shadow files
Maximum page size: 16384 bytes
Maximum cache buffers: 65536 pages


Limits per table:
Maximum number of rows per table: 4294967296 (232)
Maximum row size per table: 64 KB
Maximum number of fields per table: Depends on data types used (see Maximum row size)
Maximum number of indexes per table: 256

Limits per index:
Maximum size: 252 bytes
Maximum number of fields: 16

Numeric limits:
64-bit integer values are supported in a Firebird dialect 3 database
through the BIGINT data type.
Fixed-Decimal types are supported via the NUMERIC(p,s) /
DECIMAL(p,s) data types with 1 ? p ? 18, 0 ? s ? p.

String limits:
The maximal length of a CHAR field is 32767 bytes and 32765 bytes for a VARCHAR field, because Firebird adds a 2-byte size element to
each VARCHAR item. Firebird also supports a BLOB data type with SUB_TYPE 1, equivalent to CLOB and MEMO types implemented by some other DBMS. Themaximum BLOB size depends on the database page size used:
2 KB page size  512 MB
4 KB page size  4 GB
8 KB page size  32 GB
16 KB page size  256 GB

Complex query limits:
Maximum size of a SQL statement: 64 KB
Maximum number of members in an IN list: 1499
Maximum number of joinable tables: 255
Maximum number of logical operators in WHERE clause: AND: 255; OR: No limitation found (test run has been stopped by the user at 1593);