Subject | Re: [firebird-support] Re: GEN_UUID performance |
---|---|
Author | Thomas Steinmaurer |
Post date | 2011-04-03T17:56:36Z |
>> I ran a VERY simple test case on Firebird 2.5 SuperClassic on a normalGood question. I guess it's worth to be moved to firebird-devel. Will do.
>> 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?
--
With regards,
Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!