--- In firebird-support@yahoogroups.com, "Tobias Giesen"
<tobias_subscriber@t...> wrote:

> > 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

I've changed my source, so that no double updated are posted. But
it's strange that other databases don't take so long for the same
updates. I've done some testing and after sweep or backup/restore it
takes for both updates the same (short) time.

Richard