cariad_ilmara wrote:

> 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
>

This is FAQ

Please search the history for "shrink database" reduce database" and
the like

The only way to make a database file small is the back-up/restore
process, garbage collection or sweep has nothing to do with it.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br