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