Subject Re: Increasing memoryusage and decreasing performance
Author michel_messner
Hello Sean,

500000 or more updates of the same record without reading is a problem
for Firebird. Memoryusage increases fast and performance goes down.
Creating or updating different records in the same frequency is no
problem.

best regards

Michel

--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
> Michael,
>
> > problem is solved. A new collegue didn't use my update-strategy and
> > fired 10 updates per second. This is a little to much for the poor
> > firebird ;-)
>
> That is nothing for FB!
>
> I have processes which are executing 100's of transactions per second.
>
> Your problem lies in your application and how you are interacting with
> the database components -- it is not with FB.
>
>
> Sean
>