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?





Regards

Staffan

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





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