Subject Re: [firebird-support] Always use BIGINT?
Author Slavomir Skopalik


advantage of SmallInt vs INT vs BIGINT is data density (keep record shortest as possible).

If you have one column, it is irrelevant, if you have ten columns, you will see speed improvement.


Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
Mobile: +420 724 207 851
icq:199 118 333
On 30.6.2017 11:37, Köditz, Martin Martin.Koeditz@... [firebird-support] wrote:



In 2014 I was at the FB conference in Prague. If I remember correctly, Ann Harrison told the audience that there are no advantages when using SMALLINT or INT versus BIGINT. But I don’t remember the reason. Was it the block size of modern architecture? Maybe Ann can make it clear again? Or someone else. Would be great.


Thank you