Subject | Re: Increasing memoryusage and decreasing performance |
---|---|
Author | michel_messner |
Post date | 2007-05-02T08:06:34Z |
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
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
>