Subject Re: [firebird-support] Always use BIGINT?
Author Ann Harrison

On Fri, Jun 30, 2017 at 10:30 AM, Slavomir Skopalik skopalik@... [firebird-support] <> wrote:

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.

Did you test that, or just assume it?  Remember that data compression also affects
record size.