Subject Re: [firebird-support] Re: GEN_UUID performance
Author Thomas Steinmaurer
>> 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?

Good question. I guess it's worth to be moved to firebird-devel. Will do.

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!