On 5-10-2018 18:42, m_brahim11@... [firebird-support] wrote:

> I need to know please, what is the limit of record in a table with more
> than a hundred fields in FB 3 without reaching the 64 KB maximum row
> size. How many records my table must contains ?

https://www.firebirdsql.org/en/firebird-technical-specifications/ says:

Maximum size of one table ~18 TB
Maximum number of rows per table > 2^40
Maximum row size 64 KB

So 18 TB / 64 KB
=> 18 * 1024^4 bytes / 64 * 1024 bytes
=> 18 * 1024^3 / 64
=> 18 * 1024 * 1024^2 / 64
=> 18 * 16 * 1024 * 1024
= 301,989,888

So, depending on the actual row size, somewhere between 300 million and
2^40 (1,099,511,627,776).

Take this calculation with a grain of salt, there may be some additional
overhead which reduces this to a lower number.

Mark
--
Mark Rotteveel