On 5-10-2018 18:42, m_brahi...@yahoo.fr [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
