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:skopalik@...
http://www.elektlabs.cz

 

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