Subject Re: [firebird-support] My uncommited transaction is growing fast
Author Ann W. Harrison
Mohammad Jeffry wrote:
> Thanks for the input. I'll suggest this to my developer. I would imagine
> checking the "unclose" db connection in the source code gonna take some time
> because this is a very huge application. While waiting for the dev team to
> finish on that, the production system need to go on. The only temporary
> measue is to do a backup restore to improve the db performance...

No need to backup and restore. Just shutdown the database (or server)
and restart it. That will kill all open transactions.