Dear Ann,
Restarting the db didn't reduce the diff between Oldest transaction and
Oldest active for my FB. Is this not normal?

On 10/7/06, Ann W. Harrison <aharrison@...> wrote:
>
> 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.
>
>
> Regards
>
>
> Ann
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>


--
And whoever does an atom's weight of evil will see it.


[Non-text portions of this message have been removed]