Subject | Re: [firebird-support] Compacting Database |
---|---|
Author | budi@online.ie |
Post date | 2004-05-20T00:24:02Z |
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@...>:
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
>
>
>
>
>
>