Subject | Re: [firebird-support] Size limit for db |
---|---|
Author | Elmar Haneke |
Post date | 2011-06-07T07:30Z |
> I would like to limit the size of my firebird db. Is it possible?When the amount of data hold in DB is limited the file should not grow
infinitely.
> Obviuosly I periodically delete record in table to save space, butIt should not be necessary to shrink database since free space inside
> the only way I found to decrease db size is to export and import it
> through gbak. I would like to do it without disconnect my application
> to db?
database is recycled once the entire page contains deleted data only and
the corresponding transactions are finished.
Periodically deleting records shold be sufficient in your situation.
Elmar