Hi,
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.
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-----------------------------------------------------------------
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---------------------------------------------------------------
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz
On 30.6.2017 11:37, Köditz, Martin martin.koed...@it-syn.de
[firebird-support] wrote:
Hi,
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
Martin