>> 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) :)
Regards,
Vlad
------------------------------------------------------------------------------
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
