| Subject | Re: Performance implications of BIGINT vs INTEGER primary keys |
|---|---|
| Author | vandy899 |
| Post date | 2005-02-13T20:34Z |
--- In firebird-support@yahoogroups.com, sugi <truesaint@c...> wrote:
if 64-bit ints were not platform native, it would only be half the
speed at comparing the keys, a small part of the join stuff (Query
Planner is more expensive).
Cheers,
Michael
> Hello..,I don't know, but I honestly don't think it would be that great. Even
>
> I'm wondering if there's an associated performance penalty for using
> BIGINT as opposed to INTEGER for primary/surrogate keys. Would anyone
> have a ballpark figure / estimation of how much slower it would be?
>
> Thanks in advance.
if 64-bit ints were not platform native, it would only be half the
speed at comparing the keys, a small part of the join stuff (Query
Planner is more expensive).
Cheers,
Michael