Subject RE: [firebird-support] FB 1.5 RC6 linear slowdown
Author Alan McDonald
> I have been reading this discusion with interest.
> We have the same behaviour, the users tell us the application slows up
> as the day progress.
> As far as I can tell the only tuning you can do is a backup and restore.
> We have done this but we have the same problem.
> Our PHP application is running on Apache and we have common OS Win XP
> Pro.
> I don't have a win 2000 server box but will be making it up. I suspect
> Win XP. The XP box is a 2 GHZ athlon with 1 GB
> RAM.
> Firebird is also new to me and looks to be a great db. I have been
> building data base apps for the last 20 years and this has got me
> stumped.
> Victor

When Martijn refers to long running transactions, he means transactions
which go on for along time between commits. Not a long running query.

Can both you guys make sure that your apps commit regularly? This moves the
transactions along.