Subject Re: [firebird-support] Re: GEN_UUID performance
Author Thomas Steinmaurer
> Wow, that's a hugh difference. I suspected there would be some penalty, but
> never thought it would be that great. Nice going on the benchmark.

The basic outcome with additional tests was, that using a numeric pk
value pretty much behaves as a GUID, if the numeric pk value isn't feed
by a generator/sequence providing an increasing number, but with a
somehow random value. It's possibly related to keeping the index tree
in-sync with newly inserted records.

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!