On 03-04-2011 14:59, Thomas Steinmaurer wrote: > Hello, > > any ideas why inserting 1 million records with a GUID primary key using > the built-in GEN_UUID() function takes WAY longer than with an integer > primary key. My finding: > > 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! > Please benchmark what times it takes to just call GEN_UUID 1 million of times.
Adriano ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
