Subject Re: [firebird-support] Compacting Database
Author budi@online.ie
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 ?

Thank you

Budi

Quoting "emel.hu" <emel@...>:

>
> > Everytime i delete records i should do backup and restore ? there's no
> command
> > for simplyfying this ?
>
> No, It's not DBF;))
>
> 1./ You need this free pages for another insert.
> (and versioning updates too).
> 2./ Why drop the server time by pack?
>
> eMeL
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>