Subject Re: [firebird-support] Oldest transaction
Author Ann W. Harrison
> Ann, I was wondering if there is anything you can do at the application
> level to ensure that transactions are really committed ?

Sadly, there's really nothing you can do to be sure that a transaction
commits. The best database designers have been able to create is a
fair amount of certainty that if something fails, it gets cleaned up.

> I mean, if a system crashes, it's already too late to intervene.
> The application terminated already. But I guess that is why sweep
> is there. In case of crash, later on the sweep will do the cleanup ?

Yes, that's why sweep exists. It's a lot cheaper than a full backup and