"АТ" <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);

Привет всем!

А существует ли спецификация по ограничениям Firebird 1.5?
Очень нужна информация по максимальному количеству одновременных
подключений к базе данных и т.п. Пока смог найти только
"http://firebird.sourceforge.net/guide/FBFactsheet.html"
Но там мало цифр.

С уважением,
Андрей Терехин.

Здравствуйте, wellwell, Вы писали:

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

Спасибо, это мне очень помогло. Оказалось, что про кол-во подключений так же есть еще и в
документации:
OpGuide.pdf (InterBase 6 Operations Guide)

Maximum number of clients
connected to one server

There is no single number for the maximum number of clients the
InterBase server can serve—it depends on a combination of
factors including capability of the operating system, limitations of
the hardware, and the demands that each client puts on the
server.
Assuming a “normal” type of client application that executes
database operations from human interaction, and a modern
server platform (Pentium 150MHz+, 64Mb RAM), expect the
InterBase server to comfortably handle up to 150 clients.
This is a guideline, not a guarantee. Applications that engage in
high levels of contention or that perform complex or high-volume
operations could cause the practical number of clients to be fewer.
Note also that some operating systems do not have the
technology to serve 150 incoming network connections.

С уважением,
Андрей Терехин.