Subject Re: [firebird-support] Re: GEN_UUID performance
Author Michael Ludwig
Thomas Steinmaurer schrieb am 03.04.2011 um 14:06 (+0200):

> I ran a VERY simple test case on Firebird 2.5 SuperClassic on a normal
> desktop, so no fancy IO etc. with a 8K page size database inserting
> one million records into a two column table. The one database with a
> table with CHAR(16) OCTSETS using the built-in GEN_UUID() function for
> generating a GUID and in another database a table with a simple BIGINT
> and a generator.
> After inserting: While it's not a big surprise that the GUID databases
> has more pages allocated (GUID-DB: 12826 vs. INT-DB: 8392), an
> interesting outcome is that the inserting process (a simple stored
> procedures) finishes in the INT-DB in ~ 15 sec., whereas in the
> GUID-DB, it takes ~ 50 minutes!

Hehe. But, you know, them GUIDs, they're kinda more unique, so I guess
it's worth the overhead. 8-)

If I knew C++, I'd take a look at the algorithm. Maybe it is taking
a look at the machine's MAC address each time around?

Michael Ludwig