Subject Re: GDB file grows
Author tmiravet
I will check the difference between those values, although I think it
was not big.

I never do a commit retaining, and usually transactions are just open
for updating data and inmediatly commit.

--- In, "Martijn Tonies"
<m.tonies@u...> wrote:
> Hi,
> > I cannot say to you the exact value -I am not now where the
> > problematic BD is- but this morning I took a look at the
> > and I saw a value around 2000 in 'Oldest transaction, 'Oldest
> > active', 'Oldest snapshot' and 'Next transaction'. I realized it
> > quite big, but I didn't know if those values where normal or not.
> The difference needs to be as small as possible. Large gaps
> between those numbers can cause garbage to build up, thus
> causing database growth.
> > If you could give me some advise with this information, perfect,
> > not, as soon as I could get the actual gstat information I will
> > it.
> >
> > In any case, if, as you say, the transactions are messed up, what
> > be done to fix them. This morning I have gbak and gfix the BD but
> > seems it didn't solve the problem.
> Keep your transactions as short as possible. Do a COMMIT and
> Do you have long transactions open for reading data?
> With regards,
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL
> Server.
> Upscene Productions