--- In firebird-support@yahoogroups.com, German Pablo Gentile
<listas.ggentile@c...> wrote:

> lutz_mueller2003 wrote:
>
> >
> >the actual statement ist this:
> >UPDATE REPORTKONTOTAG SET SUMME=SUMME+?,MENGE=MENGE+? WHERE
> >FK_REPORTKONTO_ID=? AND DATUM=?
> >
> >it is executed as an prepared statement with jayBird 1.5.4
> >the updates come from a file with 1000 lines. each line causes a
> >callback while the file is read. the callback method performs the
> >update-operation (and an insert on a different database, but the
> >times for the insert remain static, and commenting out the insert
> >makes no difference). of course i could (and propably will) sum

up

> >the values in one file programmaticaly which would leave me with

one

> >update per file and transaction. but the cost for an update will
> >still rise and become a problem sooner or later.
> >how come the time for an insert remains static while the cost for

an

> >update keeps growing?
> >
> >
> Multiple versions of the record, uncomited changes in some places.
>
> >one thing i forgot to mention: after a backup/restore the time

for

> >an update drops to the time the first update took. thats why i
> >thought of transactions first.
> >
> >
> >
> That confirm multiple versions.
>
> Best regards.
>
> German.

sure, but strange thing is, this is the only process running against
this database, and the transactions get started and commited one
after another.