Hello,

I use Firebird embedded 2.0.3 on Windows XP and as far as I know,
garbage collection is disabled or nearly ineffective for embedded
databases.

I tried gfix -sweep but the database size does not change by 1 byte.

The only solution I've found so far is a full backup/restore
procedure (gbak -B/gbak -R).

Am I overlooking something ? Why doesn't gfix -sweep works ? Is there
a better way to force garbage collection for embedded databases
(connection string option, command line utility, ...) ?

Thanks in advance

--
Ael