Subject | Re: How many record can I fill in a table |
---|---|
Author | pablo sanchez |
Post date | 2018-10-05T18:24:42Z |
Hi, from http://www.ibphoenix.com/resources/documents/general/doc_323
Maximum row size for user tables - 64KB.Count bytes. BLOB and ARRAY
columns each cost 8 bytes to store the ID; VARCHARs, byte length +
2;CHARs, byte-length; SMALLINT, 2; INTEGER, FLOAT, DATE and TIME, 4;
BIGINT, DOUBLE PRECISION and TIMESTAMP, 8; NUMERIC and DECIMAL, 4 or 8,
depending on precision.
Regards
Pablo Sánchez
Maximum row size for user tables - 64KB.Count bytes. BLOB and ARRAY
columns each cost 8 bytes to store the ID; VARCHARs, byte length +
2;CHARs, byte-length; SMALLINT, 2; INTEGER, FLOAT, DATE and TIME, 4;
BIGINT, DOUBLE PRECISION and TIMESTAMP, 8; NUMERIC and DECIMAL, 4 or 8,
depending on precision.
Regards
Pablo Sánchez
On 10/5/18 1:42 PM, m_brahim11@... [firebird-support] wrote:
> Hello,
>
> 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 ?
>
> Sorry if my question seems lazy.
>
> Thanks
>
>
>
>