Subject Re: [firebird-support] What does it mean when backup-restore will improve performance only for couple of days
Author Aage Johansen
Mohd. Jeffry wrote:
> What does it mean when backup-restore will improve performance only
> for couple of days and then the performance get back to be slow
> again. Any idea?


This may be a symptom of an app that ignores transaction handling. It
usually means that you will have to take another hard look at how your
application handles transactions.
Do you do explicit Commits (not CommitRetaining) (or Rollbacks) whenever
appropriate?


--
Aage J.