--- In firebird-support@yahoogroups.com, Arn <odth@...> wrote:

>
> Hi.
> Let Me explain better:
>
> I have to do some calculations or every day in a range of 60 years.
> Insert in a table the calculations of 1 day, delete it and pass to the
> next day.
>
> I must reiterate it .
> One calculation takes 3 seconds.
> But after the database reached more than 50 mega SLOWWWWWWWWWWWW DOWN.
> too much.
>
> I have done this either in Sp and Delphi, same results, an
> inacceptable growing...
>
> Thanks
>
> Arn
>

If you perform a hard commit every so often then Firebird garbage
collection can claim back some of the disk space you are filling with
garbage.

You know your application best but it sounds a little crazy to insert
into a table and then delete the row.

Dave