Re: [firebird-support] Always use BIGINT?

[Ann Harrison aharri...@ibphoenix.com [firebird-support]]

On Fri, Jun 30, 2017 at 10:30 AM, Slavomir Skopalik skopa...@elektlabs.cz
[firebird-support] <firebird-support@yahoogroups.com> 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.

Cheers,

Ann