I make a database, let's say the size is 300kb.I add thousands record, it resize
to 1,5 MB. After deleting all the records the size still 1,5 MB. Well if it will
be used by another record when i insert new records, i must check it then.
Thanks Anyway.

Budi
Quoting Dan Wilson <dwilson@...>:

> > Well here's what i'm doing anyway,,,
> >
> > I have FB database for storing million transaction every day (in a local
> > server)
> > . In the afternoon, i must transfer the data to server (Via internet) and
> > delete
> > all the transaction data in local server. So everyday i must compact the
> > database so the Hardisk space will always available for storing next data.
> > May u undserstand what i mean...Any suggestion ?
> >
>
> Why can't you just let Firebird keep the space? It will reuse it for the
> next day's data automatically. The space isn't lost.
>
> HTH,
>
> Dan.
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>