| Subject | Re: [firebird-support] Always use BIGINT? |
|---|---|
| Author | Ann Harrison |
| Post date | 2017-06-30T18:49:23Z |
On Fri, Jun 30, 2017 at 10:30 AM, Slavomir Skopalik skopalik@... [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 affectsrecord size.Cheers,Ann