|Re: [firebird-support] Re: GEN_UUID performance
> Wow, that's a hugh difference. I suspected there would be some penalty, butThe basic outcome with additional tests was, that using a numeric pk
> never thought it would be that great. Nice going on the benchmark.
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.
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server