--- In IBObjects@yahoogroups.com, "radevojvodic" wrote:

> Application without explicite Transaction (No TIB_Transaction
> component) is slowing down over time. Log out and Log in speeds up
> database access. Does anyone have expirience that introducing
> TIB_Transaction can resolve this problem?

Hmm, I always use explicit transactions myself, so I don't quite know
how it behaves, but from what you describe I'd guess there is an
internal transaction that never commits, at least not until log out,
when it either commits or rolls back. This means that Firebird has to
keep old copies of all changes that have been done since the first
transaction started, and with lots of changes to the database, it may
cause slowdown.

If you take proper care of your transactions and commit (not
CommitRetaining) fairly frequently, then Firebird can do its
housekeeping and keep your database responsive, so yes, it is likely
that using TIB_Transaction may cure your problem.

Set