Vlad, >>> Currently, I re-run the test case mentioned in my initial email. Still >>> running. I then will also run a test case where inserting GUIDs into a >>> non-indexed column will happen. Perhaps adjusting the index tree for >>> GUIDs is slow. >> >> Inserting into a table with a GUID column as primary key takes here ~62 >> minutes. Inserting into table with an non-indexed GUID column takes ~10 >> seconds. >> >> Shall I open a ticket with a proper test case? > > First, try to insert 1mln *random* INTs, i.e. not in sequential order. > Else you compare apples (sequential numbers) with oranges (random numbers) :)
Good one. This makes a difference. Will put that in a list for a possible pro/con discussion. Thanks! Thomas ------------------------------------------------------------------------------ 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
