Subject Re: Problem with Firebird slowing up
Author Svein Erling
Does this slowdown happen gradually or suddenly?

What is the difference between the oldest active transactions and next transaction?

What kind of access is typical for you? Lots of selects or lots of updates? Do each transaction span many records or just a few?


--- In, "victor_leach" <comprad@q...> wrote:
> Can anyone give me some advise. We are using Firebird Ver
> and have bought IB Manager
> to manage the tables. We have firebird running on XP Pro box. We have
> a PHP application accessing the data base and runs okay but after a
> few hours of use slows up. We boot the server and its speed picks up.
> I validated the data base using IB Manager validation and it has no
> errors.
> Do you have to pack and reload indices with this data base. If this
> is the case can someone help me as I could not find any reference to
> thsi in the Interbase Operational Guide.