Ann W. Harrison wrote:

> Lester Caine wrote:
>> 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.
>>
> Not so silly - we've been looking at the advantages of preallocating
> space for Jim's project at MySQL. For the moment, we're not doing it,
> but it's still on the list of potential performance boosts. There's
> no way to tell gbak about a minimum allocation. One could add a
> parameter dpb used on the create call to specify a minimum size and
> the server could be taught to create empty space. It's non-trivial,
> but not very hard either.
>
> The question is whether it would be useful.

Whether it is useful depends if when expanding the file space used normally is
simply adding discontinuous segments every time? Which I know is happening on
windows. Backup and restore pulls all the segments together again. So it would
be useful if the restore ALSO grabbed more space to ensure that
defragmentation is not required as soon as the next days data is added?

( What does Linux do when adding space - does it try and keep continuous?
Probably a matter of the filing system used? )

--
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