Subject Re: [firebird-support] big change after restore
Author Nick Upson
Hi Mark,

I believe I've eliminated fragmentation as the gstat output for the tables
is almost identical, no other connections to the database exist, so its not
an OIT issue


On 30 July 2013 10:07, Mark Rotteveel <mark@...> wrote:

> **
>
>
> On Tue, 30 Jul 2013 09:37:09 +0100, Nick Upson <nu@...> wrote:
> > Hi Thomas,
> >
> > I am running classic firebird 2.1, but I don't think its GC as I ran
> both a
> > sweep and a backup and still got the same, longer, time
>
> It can be a different number of issues: less fragmentation, no (or
> shorter) record version chains, large difference between OIT and the
> current transaction number in the database before backup causing continuous
> sweeps or something like that.
>
> Mark
>
>
>



--
Nick Upson, Telensa Ltd


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