Subject Re: [firebird-support] Compacting the database from a App
Author Venus Software Operations
Hi Helen

Sorry about dropping by this way in the thread.

On 16/10/2010 04:08, Helen Borrie wrote:
>
> That part is true. The other part is that now you are working in a
> transactional environment. Take very good care to complete
> transactions in a timely way - otherwise you will build up a lot of
> garbage that, in large quantities, will adversely affect impact
> performance as time goes by.
>

How can I detect this? I rely on a framework doing this, so I am not
starting and stopping any transactions. If detected what would be the
recommended action to get things back to normal. If this is possible I
would want to make it a part of regular housekeeping. I hope I
understood correct and if so asked the correct questions.

Please advise

Thanks and regards
Bhavbhuti