--- In firebird-support@yahoogroups.com, Bergbom Staffan
<Staffan.Bergbom@l...> wrote:

>
> Hi,
>
>
>
> I've, 2005-10-05, sent a question about performance degradation in

Firebird

> and was adviced
>
> to change some parameters in the Firebird.conf file.
>
> EventMemSize set to 262144
>
> LockMemSize set to 1048576
>
> LockHashSlots = 499
>
>
>
> That helped in the beginning, but after a while I recognized that

adding a

> record through a stored procedure
>
> took longer and longer time.
>
> The stored procedure makes a few lookups, updates and adds records to a
> table used as a history-log.
>

How many operations are made inside the one transaction? Firebird
automatically keeps an undo log (until a certain point), which may
cause long transactions to slow down. There is a method in the API to
prevent the creation of the log.

>
>
> A strange behavior was that suddenly the time to add a record

dropped to a

> very low value again and after that the time again
>
> started to grow.
>

Perhaps the garbage collection or sweep ran?

Adam