Thank you for your kind reply; I made a SHELL launching gfix -sweep but my problem is always there: after 255 ALTER TABLE ADD... i obtain the error 'too many version';
I purcheased the manual and I am waiting for it...probably I made some mistake in gfix...I hope the manual will help me to resolve this and others problems.-
Regards,
Luciano Bellini

----- Original Message -----
From: Puigsegur, Jordi
To: firebird-support@yahoogroups.com
Sent: Friday, April 13, 2007 6:02 PM
Subject: RE: [firebird-support] garbage collection


I wonder if is it really necessary / useful to run a gfix -sweep? Maybe
after a massive deletion or insertion of records ?

Jordi.

________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Friday, April 13, 2007 4:25 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] garbage collection

Luciano Bellini wrote:
> Hi,
> how can I cause a garbage collection without closing my program ?
> (VB and ADO - firebird 2)

With Firebird, garbage collection is a continuous activity. You don't
have to do anything. If you want to force a complete garbage collection
use gfix -sweep from the command line or through the Services API if
you're using the embedded version.

Regards,

Ann

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





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