Subject Re: [firebird-support] can you "compact" a database ?
Author Lester Caine
Ann W. Harrison wrote:
> Why do you want to release the space back to the operating system?
> 50MB of disk costs about nothing... and, in all likelihood, you'll
> be storing new data. Storing it in existing free space is quicker
> than reallocating space. Retrieving data from a less fragmented
> file is quicker than using a more fragmented file.
>
> So what are you trying to do?

Silly thought basically since my databases are now moving from sub 100Mb to
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.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php