Subject | Re: [firebird-support] can you "compact" a database ? |
---|---|
Author | Ivan Prenosil |
Post date | 2007-12-31T10:47:49Z |
> Silly thought basically since my databases are now moving from sub 100Mb toFB database file does not hold information about number of pages allocated,
> the 100 to 500Mb range.
> Is there a means of asking for a single 500Mb of space when restoring a
> database? So that we have expansion space already allocated.
it is simply derived from the size of file itself.
So, you can easily expand file size using simple OS API calls.
On Windows you just need SetFilePointer() and SetEndOfFile().
(But of course you are doing it on your own risk.)
Ivan
http://www.volny.cz/iprenosil/interbase/