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


On Sat, Jul 1, 2017 at 6:23 AM, Köditz, Martin Martin.Koeditz@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


what do you mean with alignment?


It varies from machine to machine, but generally in order to add or compare two integers
they must be aligned on a "natural" boundary.  For modern machines, the minimum
boundary is 32 bits ... I think some 64 bit machines require a 64 bit boundary, but it's
been three years since I've thought about this at all, and I could be wrong.  What that
means in practice is that when building a record in memory, Firebird pads numbers so
they fall on 32 or 64 bit boundaries.

Cheers,

Ann