> -----Original Message-----
> Scenario:
> Done some calculations
> Insert the results in a table, let say TableA Take some of
> these results and put them in another table. TableB Empty TableA.
>
> All fine, but... database GROWS from 7 Mega to 77 or more.
> Consider I must elaborate circa 60 years
> 1 year take 70 mega..............................
>
> Commit every calculation don't work.
>
> After backup restore all return normal.
>
> Any hint to avoid growing?

The first thing that comes to mind is to stop inserting data, that however,
wouldn't be useful :-) I would hazard a guess that if you didn't backup and
restore in 60 years, yet you ran garbage collection then eventually your
database would reach a natural equilibrium and growth would be small over
that time frame. If you did a backup/restore on a yearly basis you could
probably keep the overall database size to a reasonable limit.

If you check the archives on this list, you will see that FB does not
release space back to the OS, instead it marks it as unread and will re-use
it after garbage collection, as long as no transaction is still interested
in the record.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://www.tectsoft.net/ - Homepage