If you don't want to do a full backup/restore cycle on the database then
try running a sweep on it every so often.

-steve

Svein Erling Tysvær wrote:

> --- In firebird-support@yahoogroups.com, "Marcelo" wrote:
>
>> Hi All!
>> Is there any way or utility to shrink an Interbase DB. I added a lot
>> of blobs and big tables, but then they were deleted, but the .gdb kept
>> growing.
>>
>
> Hmm, if you'd said the database didn't shrink it would have been as
> expected - Firebird reuses the space for future records, without ever
> giving anything back to the file system. But "kept growing" makes me
> wonder whether there is one or more old, uncommitted transaction(s)
> somewhere. Unless you take care of your transactions, your databases
> has to keep all versions of every record, and that is never what you want.
>
> Set
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>
>
>
>