> But this:
> UPDATE CHANGEINFO SET COUNTER=37830.5083804861 WHERE (ID = 2);
> UPDATE CHANGEINFO SET COUNTER=37830.5083804861 WHERE (ID = 2);
> COMMIT;

Hi,

seems to me that updating the same rows twice within one transaction
requires a lot of internal processing, because the second updates must
relate to the first ones with many intermediate transaction-specific data to
be handled. I wouldn't normally update the same records twice within one
transaction. Maybe Firebird is not optimized for this (rare!) case.

Cheers,
Tobias