|Subject||Re: [firebird-support] Number of Firebird Users|
> I have INSERT about 100000 records in a Table, the size of the FB Database grew up to 15MBThat is normal. A Firebird database is organized in pages that are
> I DELETE the records the size remains 15MB.
allocated when needed. When you delete the records, the pages will be
marked as free and will be reused when you add more data.
> After BACKUP and RESTORE thru FlameRobin then the size was reduce to 788KbThat is also normal because GBAK (the tool that FlameRobin calls to do
the job) will build the new database from scrath and then fill it with
the data from the backup (also done with GBAK) that you have done
before. So there are no empty pages after the Restore.
> Is this normal ? or can it me done automatically within the settingsAs I said before, you don't have to do it because Firebird will reuse
> and configs
the unused pages before it will allocate new pages. So there is
nothing to worry about.
If you want to do it anyway on a regular basis you can write a batch
file that calls GBAK (which is a command-line tool) for a backup and
then again for a restore. However, you must be aware that the database
will not be usable during the restore and that everything that is
added/changed/deleted in the database *after the time the backup has
started* is lost.