Subject Performance degradation in Firebird third time
Author Bergbom Staffan
Hi all,

After testing suggestions(changing parameters in the config-file and
adjusting sweep-interval) on how to overcome degradation

when adding records to a Firebird -Db, I still have the same problems.

When I had changed the sweep-interval it first worked real well with low
insert-times(200- 300 ms) but after a while this time

is something like 13 seconds.

The test is done with an app that every minute adds a record to the Db
through a stored procedure(not optimzed but imppossible to change I have to
live with it)

The stored procedure makes a few lookups, updates and adds records to a
table used as a history-log.

The input-parameters are like: CustomerId, ObjectId, Date, Time, StatusCode

Every minute is a new record added for the same CustomerId and ObjectId just
Date and Time is changed

Every night the history-log is erased.

A peculiar thing is that even if the insert-time is as high as some 13
seconds it low again if I changed CustomerId and ObjectId.

Is there anyone that could please give me a clue on what is causing this and
what I could do to maintain low insert-times?



Staffan.Bergbom@... <mailto:Staffan.Bergbom@...>

[Non-text portions of this message have been removed]