Subject | Re: [firebird-support] can you "compact" a database ? |
---|---|
Author | Lester Caine |
Post date | 2007-12-29T08:05:21Z |
Ann W. Harrison wrote:
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
> Why do you want to release the space back to the operating system?Silly thought basically since my databases are now moving from sub 100Mb to
> 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?
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