Subject Re: [firebird-support] Re: sweep taking a long time
Author Sándor Tamás (HostWare Kft.)
thanks for help.

SanTa

----- Original Message -----
From: "Nando Dessena" <nando@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, November 10, 2005 2:33 PM
Subject: Re: [firebird-support] Re: sweep taking a long time


> Sándor,
>
> S> And what happens to the OLD database, if I let FB to do the garbage
> S> collection?
>
> it will be garbage-collected as a result of gbak visiting all records in
> the database. This has a good effect on performance since it frees
> pages for reuse and reduces the number of record back-versions.
>
> S> Because I had a corrupt database, which I could not back up. (it
> stopped
> S> backup with error messages). Then I instinctly turned off garbage
> S> collection, and FB did a corerct backup, which I can the restore. The
> DB
> S> have been working correctly since then.
>
> I am not an expert in this area, and anyway without seeing what error
> messages you got it is difficult to guess.
>
> Ciao
> --
> Nando Dessena
> ======================================================
> I support Firebird, I am a Firebird Foundation member!
> Join today at http://www.firebirdsql.org/ff/foundation
> ======================================================
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>