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.

Cheers,


Ann