Subject | Re: Re-use space |
---|---|
Author | achiadodespammed |
Post date | 2004-08-27T11:14:30Z |
--- In firebird-support@yahoogroups.com, Elmar Haneke <elmar@h...>
wrote:
Hi Elmar
monday. An old transaction can be caused by a crashed application
with a transaction opened? If so, Firebird rollback trans after a
certain time?
Thank you
Andrea Chiado' Piat
Bit Informatica srl
Torino - Italy
wrote:
Hi Elmar
> The space should be automatically reused. You should check ifI Have not a db stat now so I cant check for that. I can check it on
>there is
> an old transaction still open, this could prevent reusage since
>the
> old DB state is still kept available for that transaktion.
monday. An old transaction can be caused by a crashed application
with a transaction opened? If so, Firebird rollback trans after a
certain time?
> If there is no old transaction space reusage might be limited byinfinitely.
> fragmentation. But, the fragmentation overhead should not grow
>So gbak and gfix -sweep are the right tasks to run?
> Elmar
Thank you
Andrea Chiado' Piat
Bit Informatica srl
Torino - Italy