Hi all,

I had to insert 300.000 records in a table with no indices or triggers except the primary key, which is type "char(16), character set octets".

With the primary key, it took 40 minutes to insert all records.

Removing the primary key, it took 1m40s to insert all records.

Both tests were done using a just restored database, forced-writes off, firebird 2.5, and the same machine.

Is this difference expected? Maybe it is related to the type of the primary key?

Is there something i can do to improve the performance?

Regards,

Fabiano