Subject | Re: [firebird-support] Re: Implement maximum database size |
---|---|
Author | Woody |
Post date | 2007-12-18T16:10:52Z |
btrumba wrote:
the database to a set size and then limit that instead of the actual
size. Start with an empty database and fill it with information until it
hits the size you want to limit it to.
The problem with size is that it's not an indication of the actual
amount of data. Deletions only remove the record from view, not from the
database file itself. That only happens when you backup and restore.
Woody (TMW)
> Sorry, I was unclear:Why not calculate the approximate amount of records/data that would grow
>
> I want to LIMIT database size. One user is using database. E.g.: let
> say that user can only insert 100Mb of data into database.
the database to a set size and then limit that instead of the actual
size. Start with an empty database and fill it with information until it
hits the size you want to limit it to.
The problem with size is that it's not an indication of the actual
amount of data. Deletions only remove the record from view, not from the
database file itself. That only happens when you backup and restore.
Woody (TMW)